Microsoft Excel Worksheet Functions

Post thread
N
Errors encountered when using If & Vlookup formulas
  • nikko
Replies
2
Views
534
nikko
N
J
SUMIFS and dates
  • JLR-Mart
Replies
3
Views
618
Fred Smith
F
R
Advanced Criteria for SUMIF
  • Roberto Villa Real
Replies
4
Views
788
Hambo_NZ
H
M
Slicing Data (Alternative to SUMIFS)
  • Marcelo
Replies
2
Views
2K
Ashish Mathur
A
C
Method for creating formulas to reference different worksheets?
  • copticdred
Replies
3
Views
4K
Gord Dibben
G
S
Sumproduct Question
  • ShagNasty
Replies
1
Views
325
Sheeloo
S
C
Formula Help
  • CHerzog
Replies
1
Views
284
T. Valko
T
L
index and match, then subtract, divide and add for my final answer
  • ladygr
Replies
3
Views
2K
ladygr
L
B
sum cells with both alpha and values but...
  • bluthjen
Replies
0
Views
407
bluthjen
B
T
Alternative to using 10 V-lookup formulas
  • Tami
Replies
2
Views
341
T. Valko
T
M
How do I recalculate cell only if reference cell value changes?
  • murph
Replies
4
Views
617
murph
M
O
Copying a cell ref. down a column, changing worksheet # along the
  • olivia
Replies
5
Views
807
2traksDavid
2
T
Text into Columns
  • tcmh
Replies
3
Views
316
Dave Peterson
D
D
combining data from multiple workbooks
  • dslocum
Replies
5
Views
666
Dave Peterson
D
C
"IF" function returns function instead of result
  • ckrogers
Replies
6
Views
548
Jarek Kujawa
J
C
IF function returns function statement rather than result
  • ckrogers
Replies
3
Views
466
ckrogers
C
C
Can't save Excel spreadsheets
  • Claire
Replies
1
Views
383
Kassie
K
G
Help with VLOOKUP & MATCH formula
  • GoBucks
Replies
5
Views
676
GoBucks
G
R
EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
  • robin l
Replies
4
Views
873
Susan
S
C
Percentage over a date range
  • CP
Replies
3
Views
517
Eduardo
E
R
CANT INSERT CELLS, ONLY ROWS & COLUMNS
  • robin l
Replies
1
Views
374
Jacob Skaria
J
B
Is there a Conditional Sum Wizard in Office 07? If so Where
  • Brian86
Replies
2
Views
286
T. Valko
T
T
data in 2nd column associated with =MAX(H1:H100) from another colu
  • tcek
Replies
2
Views
368
Mike H
M
A
Highlighting the entire row with conditional formatting
  • Allen
Replies
10
Views
1K
T. Valko
T
T
data associated with latest date
  • tcek
Replies
5
Views
424
tcek
T
C
How to count/tally entries?
  • chrisk
Replies
1
Views
446
chrisk
C
P
Text to rows
  • Phippsy
Replies
6
Views
355
Phippsy
P
W
Lookup Function
  • Wasdell
Replies
2
Views
303
klswvu
K
P
how to move contents in column up one cell
  • pmt
Replies
2
Views
479
klswvu
K
S
Today() function
  • Steve
Replies
2
Views
403
Luke M
L
P
Flatten password file
  • PSM
Replies
3
Views
394
Tom Hutchins
T
S
Text to Number
  • Steve
Replies
3
Views
294
Luke M
L
R
Calculate the number of hours in a date/time cell
  • richardwo
Replies
1
Views
533
Jacob Skaria
J
S
Time/priority problem
  • sonic-the-mouse
Replies
2
Views
373
Jacob Skaria
J
J
how do I use a cell from one worksheet in the equation of another
  • jpw
Replies
3
Views
364
mclwlg
M
M
Stuck on Formulas
  • megsmom85
Replies
1
Views
364
JudithJubilee
J
L
Numbers of repeats of a string
  • Luciano Paulino da Silva
Replies
11
Views
625
macropod
M
A
Taking Average ignoring #DIV/0! in the range...
  • Astro
Replies
1
Views
2K
T. Valko
T
W
EDATE Function disappears intermittently
  • Wendy
Replies
1
Views
3K
T. Valko
T
Z
Pivot Table - Old remaining values for rows
  • ZorionK
Replies
3
Views
662
ZorionK
Z
J
solver an uxexpected internal error ocurred, or available memory
  • Jorge A.
Replies
1
Views
510
Jacob Skaria
J
P
Quarters
  • PAL
Replies
1
Views
397
Jacob Skaria
J
T
filtering or selecting data baseed on time of day
  • TBA
Replies
1
Views
286
Jacob Skaria
J
K
displaying changes
  • Kackels
Replies
1
Views
272
Tom Hutchins
T
S
Help Calculating Partial Months between 2 dates.
  • sirscottyog
Replies
2
Views
1K
Ashish Mathur
A
B
SUMIF formula with non contiguous cells
  • Billy B
Replies
2
Views
2K
Ashish Mathur
A
J
Importing Data Wizard
  • John L
Replies
6
Views
299
John L
J
V
Multiple results of Unique Values
  • VickiMc
Replies
3
Views
375
Ashish Mathur
A
D
Deleting rows or columns
  • Darrell
Replies
1
Views
243
Alan
A
B
How does one use a formula to bring over the formatting as well
  • Bud
Replies
1
Views
397
Alan
A
Back
Top