Microsoft Excel Worksheet Functions

Post thread
J
countif adding AND
  • Johndb
Replies
13
Views
617
Johndb
J
L
Conditional Formatting Question
  • libby
Replies
1
Views
386
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
412
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
942
T. Valko
T
J
counting duplicates and uniques comparing two columns
  • Johndb
Replies
3
Views
564
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
912
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
461
ivory
I
M
SumProduct meeting two criteria
  • Mindy
Replies
4
Views
420
Mindy
M
B
Count based on 2 conditions
  • Basenji
Replies
4
Views
566
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
908
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
419
Max
M
J
countif with AND comparing 3 columns
  • Johndb
Replies
1
Views
495
Johndb
J
J
relative address or reference
  • James C.
Replies
1
Views
411
T. Valko
T
J
I need to simplify this...
  • j5b9721
Replies
4
Views
385
T. Valko
T
C
If statements
  • Cold1
Replies
2
Views
446
Teethless mama
T
M
I know I should know this
  • mdj0615
Replies
1
Views
358
Fred Smith
F
J
Vlookup - multiple tabs
  • jkiser
Replies
5
Views
7K
Ragdyer
R
Y
Need a Formula , please help
  • ytayta555
Replies
1
Views
496
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
801
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
692
bcw_now
B
K
Function or If statement help
  • KrissyiP
Replies
1
Views
407
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
299
Lars-Åke Aspelin
L
N
Sum sheets based on criteria
  • npop03
Replies
5
Views
426
Don Guillett
D
S
IF #N/A ( in a range), "ALERT","OK"
  • Steve
Replies
7
Views
458
Steve
S
J
alternatives to embedded ifs
  • jaime_ottawa
Replies
6
Views
778
Glenn
G
P
Function returning unexpected value
  • Paul
Replies
7
Views
395
JoeU2004
J
K
if condition combined with SMALL
  • kaveran
Replies
3
Views
440
Teethless mama
T
K
Copy line if
  • Kcope8302
Replies
10
Views
586
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
579
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
895
Luke M
L
I
Indirect reference
  • ice
Replies
2
Views
496
Sam Wilson
S
F
Different twist on ISNUMBER
  • fgwiii
Replies
6
Views
544
fgwiii
F
S
Add Range If Q
  • Seanie
Replies
1
Views
335
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
375
Dana DeLouis
D
Back
Top