Microsoft Excel Worksheet Functions

Post thread
J
countif adding AND
  • Johndb
Replies
13
Views
671
Johndb
J
L
Conditional Formatting Question
  • libby
Replies
1
Views
433
T. Valko
T
G
lookup value if multiple matches are met
  • Go Bucks!!!
Replies
2
Views
623
Go Bucks!!!
G
N
Sum if Critea 1 and critera 2 are met
  • Nelson
Replies
6
Views
463
T. Valko
T
R
Count function
  • Ranjith Kurian
Replies
7
Views
422
T. Valko
T
S
Time x Rate
  • Scott A
Replies
2
Views
436
JoeU2004
J
N
help with IF and VLOOKUP combined
  • Natalie
Replies
2
Views
658
Luke M
L
S
Help using autofilter & Sumproduct
  • Scott
Replies
4
Views
958
T. Valko
T
J
counting duplicates and uniques comparing two columns
  • Johndb
Replies
3
Views
593
T. Valko
T
S
using worksheet name in a formula but not current worksheet
  • Sing Chung
Replies
3
Views
772
T. Valko
T
S
Validation of input against the active directory
  • Sing Chung
Replies
1
Views
931
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
474
ivory
I
M
SumProduct meeting two criteria
  • Mindy
Replies
4
Views
435
Mindy
M
B
Count based on 2 conditions
  • Basenji
Replies
4
Views
646
Basenji
B
C
Fill across worksheet pages
  • Cyara
Replies
1
Views
380
Gary''s Student
G
J
Indirect reference causes statistical function to throw up a #NUM!
  • JoCa
Replies
10
Views
1K
Lori
L
G
I need to format a count in a pivot table
  • Golfer2100
Replies
2
Views
280
Jason
J
M
Working on a big spreadsheet
  • mdj0615
Replies
5
Views
440
Max
M
J
countif with AND comparing 3 columns
  • Johndb
Replies
1
Views
510
Johndb
J
J
relative address or reference
  • James C.
Replies
1
Views
424
T. Valko
T
J
I need to simplify this...
  • j5b9721
Replies
4
Views
385
T. Valko
T
C
If statements
  • Cold1
Replies
2
Views
469
Teethless mama
T
M
I know I should know this
  • mdj0615
Replies
1
Views
370
Fred Smith
F
J
Vlookup - multiple tabs
  • jkiser
Replies
5
Views
7K
Ragdyer
R
Y
Need a Formula , please help
  • ytayta555
Replies
1
Views
512
ytayta555
Y
M
Calculate Future Date but don't want
  • Morocco Mole
Replies
6
Views
845
Ron Rosenfeld
R
B
Random Numbers excluding Previous Numbers
  • Brad
Replies
2
Views
817
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
745
Max
M
B
Can users perform a reverse lookup
  • Blue Max
Replies
7
Views
757
bcw_now
B
K
Function or If statement help
  • KrissyiP
Replies
1
Views
429
Fred Smith
F
D
The date in a excel worksheet is wrong. =now() responds 1-0-1900
  • David
Replies
3
Views
592
Ron Rosenfeld
R
J
If, then
  • Joseph
Replies
1
Views
332
Lars-Åke Aspelin
L
N
Sum sheets based on criteria
  • npop03
Replies
5
Views
473
Don Guillett
D
S
IF #N/A ( in a range), "ALERT","OK"
  • Steve
Replies
7
Views
525
Steve
S
J
alternatives to embedded ifs
  • jaime_ottawa
Replies
6
Views
802
Glenn
G
P
Function returning unexpected value
  • Paul
Replies
7
Views
424
JoeU2004
J
K
if condition combined with SMALL
  • kaveran
Replies
3
Views
458
Teethless mama
T
K
Copy line if
  • Kcope8302
Replies
10
Views
648
Kcope8302
K
L
Unique values
  • LiAD
Replies
4
Views
528
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
610
Eduardo
E
I
Help with complex "IF" formula !!!
  • Iriemon
Replies
2
Views
353
Sam Wilson
S
L
Return date if in range, else return blank
  • LisaL
Replies
1
Views
922
Luke M
L
I
Indirect reference
  • ice
Replies
2
Views
542
Sam Wilson
S
F
Different twist on ISNUMBER
  • fgwiii
Replies
6
Views
588
fgwiii
F
S
Add Range If Q
  • Seanie
Replies
1
Views
346
Seanie
S
U
countif/sumproduct = criteria with weeknum
  • ummone
Replies
2
Views
2K
Jacob Skaria
J
K
Named Array
  • KC Excel Qns
Replies
7
Views
407
Dana DeLouis
D
Back
Top