Microsoft Excel Worksheet Functions

Post thread
J
countif adding AND
  • Johndb
Replies
13
Views
619
Johndb
J
L
Conditional Formatting Question
  • libby
Replies
1
Views
391
T. Valko
T
G
lookup value if multiple matches are met
  • Go Bucks!!!
Replies
2
Views
601
Go Bucks!!!
G
N
Sum if Critea 1 and critera 2 are met
  • Nelson
Replies
6
Views
425
T. Valko
T
R
Count function
  • Ranjith Kurian
Replies
7
Views
391
T. Valko
T
S
Time x Rate
  • Scott A
Replies
2
Views
416
JoeU2004
J
N
help with IF and VLOOKUP combined
  • Natalie
Replies
2
Views
636
Luke M
L
S
Help using autofilter & Sumproduct
  • Scott
Replies
4
Views
944
T. Valko
T
J
counting duplicates and uniques comparing two columns
  • Johndb
Replies
3
Views
569
T. Valko
T
S
using worksheet name in a formula but not current worksheet
  • Sing Chung
Replies
3
Views
737
T. Valko
T
S
Validation of input against the active directory
  • Sing Chung
Replies
1
Views
917
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
462
ivory
I
M
SumProduct meeting two criteria
  • Mindy
Replies
4
Views
422
Mindy
M
B
Count based on 2 conditions
  • Basenji
Replies
4
Views
588
Basenji
B
C
Fill across worksheet pages
  • Cyara
Replies
1
Views
378
Gary''s Student
G
J
Indirect reference causes statistical function to throw up a #NUM!
  • JoCa
Replies
10
Views
966
Lori
L
G
I need to format a count in a pivot table
  • Golfer2100
Replies
2
Views
268
Jason
J
M
Working on a big spreadsheet
  • mdj0615
Replies
5
Views
422
Max
M
J
countif with AND comparing 3 columns
  • Johndb
Replies
1
Views
496
Johndb
J
J
relative address or reference
  • James C.
Replies
1
Views
414
T. Valko
T
J
I need to simplify this...
  • j5b9721
Replies
4
Views
385
T. Valko
T
C
If statements
  • Cold1
Replies
2
Views
447
Teethless mama
T
M
I know I should know this
  • mdj0615
Replies
1
Views
359
Fred Smith
F
J
Vlookup - multiple tabs
  • jkiser
Replies
5
Views
7K
Ragdyer
R
Y
Need a Formula , please help
  • ytayta555
Replies
1
Views
500
ytayta555
Y
M
Calculate Future Date but don't want
  • Morocco Mole
Replies
6
Views
793
Ron Rosenfeld
R
B
Random Numbers excluding Previous Numbers
  • Brad
Replies
2
Views
808
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
734
Max
M
B
Can users perform a reverse lookup
  • Blue Max
Replies
7
Views
726
bcw_now
B
K
Function or If statement help
  • KrissyiP
Replies
1
Views
409
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
308
Lars-Åke Aspelin
L
N
Sum sheets based on criteria
  • npop03
Replies
5
Views
436
Don Guillett
D
S
IF #N/A ( in a range), "ALERT","OK"
  • Steve
Replies
7
Views
478
Steve
S
J
alternatives to embedded ifs
  • jaime_ottawa
Replies
6
Views
779
Glenn
G
P
Function returning unexpected value
  • Paul
Replies
7
Views
399
JoeU2004
J
K
if condition combined with SMALL
  • kaveran
Replies
3
Views
443
Teethless mama
T
K
Copy line if
  • Kcope8302
Replies
10
Views
599
Kcope8302
K
L
Unique values
  • LiAD
Replies
4
Views
496
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
583
Eduardo
E
I
Help with complex "IF" formula !!!
  • Iriemon
Replies
2
Views
338
Sam Wilson
S
L
Return date if in range, else return blank
  • LisaL
Replies
1
Views
900
Luke M
L
I
Indirect reference
  • ice
Replies
2
Views
502
Sam Wilson
S
F
Different twist on ISNUMBER
  • fgwiii
Replies
6
Views
554
fgwiii
F
S
Add Range If Q
  • Seanie
Replies
1
Views
337
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
379
Dana DeLouis
D
Back
Top