Microsoft Excel Worksheet Functions

Post thread
J
countif adding AND
  • Johndb
Replies
13
Views
615
Johndb
J
L
Conditional Formatting Question
  • libby
Replies
1
Views
385
T. Valko
T
G
lookup value if multiple matches are met
  • Go Bucks!!!
Replies
2
Views
599
Go Bucks!!!
G
N
Sum if Critea 1 and critera 2 are met
  • Nelson
Replies
6
Views
419
T. Valko
T
R
Count function
  • Ranjith Kurian
Replies
7
Views
386
T. Valko
T
S
Time x Rate
  • Scott A
Replies
2
Views
411
JoeU2004
J
N
help with IF and VLOOKUP combined
  • Natalie
Replies
2
Views
629
Luke M
L
S
Help using autofilter & Sumproduct
  • Scott
Replies
4
Views
940
T. Valko
T
J
counting duplicates and uniques comparing two columns
  • Johndb
Replies
3
Views
545
T. Valko
T
S
using worksheet name in a formula but not current worksheet
  • Sing Chung
Replies
3
Views
730
T. Valko
T
S
Validation of input against the active directory
  • Sing Chung
Replies
1
Views
911
Hii Sing Chung
H
J
Delete extra pages in Excel 2007
  • Jo Watson
Replies
2
Views
1K
Shane Devenshire
S
I
How do I set up a function in excel to give either a <> or =?
  • ivory
Replies
3
Views
460
ivory
I
M
SumProduct meeting two criteria
  • Mindy
Replies
4
Views
419
Mindy
M
B
Count based on 2 conditions
  • Basenji
Replies
4
Views
549
Basenji
B
C
Fill across worksheet pages
  • Cyara
Replies
1
Views
375
Gary''s Student
G
J
Indirect reference causes statistical function to throw up a #NUM!
  • JoCa
Replies
10
Views
861
Lori
L
G
I need to format a count in a pivot table
  • Golfer2100
Replies
2
Views
267
Jason
J
M
Working on a big spreadsheet
  • mdj0615
Replies
5
Views
416
Max
M
J
countif with AND comparing 3 columns
  • Johndb
Replies
1
Views
494
Johndb
J
J
relative address or reference
  • James C.
Replies
1
Views
410
T. Valko
T
J
I need to simplify this...
  • j5b9721
Replies
4
Views
384
T. Valko
T
C
If statements
  • Cold1
Replies
2
Views
445
Teethless mama
T
M
I know I should know this
  • mdj0615
Replies
1
Views
356
Fred Smith
F
J
Vlookup - multiple tabs
  • jkiser
Replies
5
Views
7K
Ragdyer
R
Y
Need a Formula , please help
  • ytayta555
Replies
1
Views
495
ytayta555
Y
M
Calculate Future Date but don't want
  • Morocco Mole
Replies
6
Views
779
Ron Rosenfeld
R
B
Random Numbers excluding Previous Numbers
  • Brad
Replies
2
Views
800
Jim Cone
J
B
vlookup column based on user input
  • berniean
Replies
5
Views
1K
Max
M
H
CORREL w/ condition
  • heidi
Replies
5
Views
733
Max
M
B
Can users perform a reverse lookup
  • Blue Max
Replies
7
Views
681
bcw_now
B
K
Function or If statement help
  • KrissyiP
Replies
1
Views
406
Fred Smith
F
D
The date in a excel worksheet is wrong. =now() responds 1-0-1900
  • David
Replies
3
Views
591
Ron Rosenfeld
R
J
If, then
  • Joseph
Replies
1
Views
298
Lars-Åke Aspelin
L
N
Sum sheets based on criteria
  • npop03
Replies
5
Views
423
Don Guillett
D
S
IF #N/A ( in a range), "ALERT","OK"
  • Steve
Replies
7
Views
457
Steve
S
J
alternatives to embedded ifs
  • jaime_ottawa
Replies
6
Views
777
Glenn
G
P
Function returning unexpected value
  • Paul
Replies
7
Views
393
JoeU2004
J
K
if condition combined with SMALL
  • kaveran
Replies
3
Views
439
Teethless mama
T
K
Copy line if
  • Kcope8302
Replies
10
Views
584
Kcope8302
K
L
Unique values
  • LiAD
Replies
4
Views
488
Ashish Mathur
A
M
find last populated cell in range of cells
  • Maximus
Replies
6
Views
1K
T. Valko
T
S
SUMIF criteria in different column is met?
  • spandangled
Replies
3
Views
578
Eduardo
E
I
Help with complex "IF" formula !!!
  • Iriemon
Replies
2
Views
335
Sam Wilson
S
L
Return date if in range, else return blank
  • LisaL
Replies
1
Views
891
Luke M
L
I
Indirect reference
  • ice
Replies
2
Views
495
Sam Wilson
S
F
Different twist on ISNUMBER
  • fgwiii
Replies
6
Views
540
fgwiii
F
S
Add Range If Q
  • Seanie
Replies
1
Views
334
Seanie
S
U
countif/sumproduct = criteria with weeknum
  • ummone
Replies
2
Views
1K
Jacob Skaria
J
K
Named Array
  • KC Excel Qns
Replies
7
Views
373
Dana DeLouis
D
Back
Top