Microsoft Excel Worksheet Functions

Post thread
N
Errors encountered when using If & Vlookup formulas
  • nikko
Replies
2
Views
525
nikko
N
J
SUMIFS and dates
  • JLR-Mart
Replies
3
Views
613
Fred Smith
F
R
Advanced Criteria for SUMIF
  • Roberto Villa Real
Replies
4
Views
787
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
316
Sheeloo
S
C
Formula Help
  • CHerzog
Replies
1
Views
283
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
403
bluthjen
B
T
Alternative to using 10 V-lookup formulas
  • Tami
Replies
2
Views
334
T. Valko
T
M
How do I recalculate cell only if reference cell value changes?
  • murph
Replies
4
Views
616
murph
M
O
Copying a cell ref. down a column, changing worksheet # along the
  • olivia
Replies
5
Views
800
2traksDavid
2
T
Text into Columns
  • tcmh
Replies
3
Views
314
Dave Peterson
D
D
combining data from multiple workbooks
  • dslocum
Replies
5
Views
661
Dave Peterson
D
C
"IF" function returns function instead of result
  • ckrogers
Replies
6
Views
536
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
380
Kassie
K
G
Help with VLOOKUP & MATCH formula
  • GoBucks
Replies
5
Views
669
GoBucks
G
R
EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
  • robin l
Replies
4
Views
867
Susan
S
C
Percentage over a date range
  • CP
Replies
3
Views
509
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
364
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
410
tcek
T
C
How to count/tally entries?
  • chrisk
Replies
1
Views
442
chrisk
C
P
Text to rows
  • Phippsy
Replies
6
Views
339
Phippsy
P
W
Lookup Function
  • Wasdell
Replies
2
Views
302
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
397
Luke M
L
P
Flatten password file
  • PSM
Replies
3
Views
387
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
526
Jacob Skaria
J
S
Time/priority problem
  • sonic-the-mouse
Replies
2
Views
365
Jacob Skaria
J
J
how do I use a cell from one worksheet in the equation of another
  • jpw
Replies
3
Views
358
mclwlg
M
M
Stuck on Formulas
  • megsmom85
Replies
1
Views
363
JudithJubilee
J
L
Numbers of repeats of a string
  • Luciano Paulino da Silva
Replies
11
Views
609
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
652
ZorionK
Z
J
solver an uxexpected internal error ocurred, or available memory
  • Jorge A.
Replies
1
Views
503
Jacob Skaria
J
P
Quarters
  • PAL
Replies
1
Views
388
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
365
Ashish Mathur
A
D
Deleting rows or columns
  • Darrell
Replies
1
Views
239
Alan
A
B
How does one use a formula to bring over the formatting as well
  • Bud
Replies
1
Views
395
Alan
A
Back
Top