Microsoft Excel Worksheet Functions

C
Concatenate many rows quickly
  • cmotes
Replies
4
Views
16K
T. Valko
T
V
Averaging set of data based on the time
  • voyager1
Replies
2
Views
325K
voyager1
V
K
How do I change the name on comments inserted in Excel
  • Kit
Replies
1
Views
120K
Bob Phillips
B
D
make a positive number to negative
  • D
Replies
2
Views
306K
Stan Brown
S
S
Returning matches from mutiple rows
  • Sunshine
Replies
4
Views
286K
T. Valko
T
J
converting files to excel
  • jes
Replies
3
Views
238K
volelo
V
N
Using Solver
  • needhelpplease
Replies
2
Views
231K
Dana DeLouis
D
A
Drop Down Menu autofilling
  • Aaron
Replies
6
Views
181K
Gord Dibben
G
K
How do I vlookup multiple rows with same reference?
  • Kathie C
Replies
2
Views
370K
Herbert Seidenberg
H
B
Text to Numbers
  • Batshon
Replies
4
Views
104K
Gord Dibben
G
J
calculating by month
  • Jake
Replies
1
Views
151K
Bob Phillips
B
G
Adding fileds in a list based on a lookup
  • Gregory Day
Replies
5
Views
114K
sahafi
S
D
Sunday
  • Dale
Replies
6
Views
165K
Ron Rosenfeld
R
R
separating linked wrkbooks
  • robzrob
Replies
5
Views
97K
JLatham
J
R
help with code in a mack
  • Richard
Replies
5
Views
199K
Dave Peterson
D
T
IF function - If false argument query
  • Twishlist
Replies
5
Views
354K
Max
M
R
date and time [skipping weekends]
  • rhhince
Replies
8
Views
237K
rhhince
R
J
Manipulating data in Multible worksheets
  • Jason Cottrell
Replies
2
Views
184K
Jason Cottrell
J
M
shortcut key for selecting the inactive cells surrounding a range
  • Michele
Replies
1
Views
189K
Héctor Miguel
H
S
VLookup and cell shading
  • Sherry
Replies
2
Views
127K
mvk
M
L
Date Range Conditional Formatting
  • Lynn
Replies
13
Views
694K
T. Valko
T
C
VLOOKUP
  • Clay_TX
Replies
4
Views
397K
Pete_UK
P
R
Zero Values
  • robzrob
Replies
2
Views
270K
robzrob
R
J
Cumulative days roll-over
  • John MacAllister
Replies
7
Views
236K
John MacAllister
J
K
Table feature in Data Menu
  • Katie
Replies
6
Views
73K
Max
M
M
Conditional formatting II
  • Mac
Replies
4
Views
78K
Mac
M
D
Is there a limit to the number of formulas in an Excel worksheet?
  • Del
Replies
3
Views
80K
JP
J
M
pulling data from 2 columns
  • MJJ
Replies
3
Views
400K
Pete_UK
P
T
Duplicate rows into new rows based on row value
  • Tom
Replies
5
Views
296K
ryguy7272
R
M
Conditional formatting
  • Mac
Replies
3
Views
58K
Mac
M
C
trying to consolidate info into one sheet
  • cabirdy
Replies
1
Views
178K
Herbert Seidenberg
H
J
PageSetup Macro
  • Julian Glass
Replies
1
Views
32K
Stan Brown
S
E
help on sumproduct() - sum by searching for a common sub string in
  • Eddy Stan
Replies
12
Views
198K
Bob Phillips
B
R
Search and replace function
  • RichardR
Replies
1
Views
169K
Pete_UK
P
J
Generating a new list based on cell criteria
  • JerryS
Replies
1
Views
175K
Max
M
T
Need Formula to Find a Match and Then Insert Some Characters
  • Toria
Replies
4
Views
506K
Pete_UK
P
G
Convert minutes into hours and minutes
  • Guest
Replies
6
Views
641K
Niek Otten
N
T
Pasting Borders
  • TigerLady
Replies
2
Views
229K
Ken Johnson
K
N
Excel Formula to concatenate record from 2 tables
  • Negda
Replies
3
Views
254K
Herbert Seidenberg
H
K
Conditional Calculations with Calculated Results
  • Koneko
Replies
1
Views
177K
Pete_UK
P
G
Conditional Format Based on Age, but not if blank.
  • Gregory Day
Replies
7
Views
481K
Pete_UK
P
G
Count Days more than 180 days prior to today
  • Gregory Day
Replies
4
Views
443K
Gregory Day
G
J
Linking values within an Excel workbook
  • Jerry M.
Replies
1
Views
37K
ryguy7272
R
J
How to concatenate cell & text in a text box?
  • Jimbo213
Replies
3
Views
361K
ryguy7272
R
A
#n/a result for vlookup
  • adimar
Replies
5
Views
347K
adimar
A
C
How to force data entry with error messages
  • CindyB
Replies
1
Views
231K
CindyB
C
S
Sumproduct Offset with an If
  • Steve
Replies
2
Views
275K
[email protected]
K
B
Copying formulas
  • bridgeb3
Replies
1
Views
320K
Pete_UK
P
S
Need formula in excel for filtering large database
  • Sharkies
Replies
2
Views
116K
Sharkies
S
S
Change a 1,2,3 or 4 digit number to a 6 character text string
  • Steve D
Replies
3
Views
366K
Pete_UK
P
You must log in or register to post here.
Back
Top