Microsoft Excel Worksheet Functions

L
Conditional Formatting Question
  • libby
Replies
1
Views
268K
T. Valko
T
G
lookup value if multiple matches are met
  • Go Bucks!!!
Replies
2
Views
248K
Go Bucks!!!
G
N
Sum if Critea 1 and critera 2 are met
  • Nelson
Replies
6
Views
363K
T. Valko
T
R
Count function
  • Ranjith Kurian
Replies
7
Views
651K
T. Valko
T
S
Time x Rate
  • Scott A
Replies
2
Views
313K
JoeU2004
J
N
help with IF and VLOOKUP combined
  • Natalie
Replies
2
Views
224K
Luke M
L
S
Help using autofilter & Sumproduct
  • Scott
Replies
4
Views
236K
T. Valko
T
J
counting duplicates and uniques comparing two columns
  • Johndb
Replies
3
Views
259K
T. Valko
T
S
using worksheet name in a formula but not current worksheet
  • Sing Chung
Replies
3
Views
276K
T. Valko
T
S
Validation of input against the active directory
  • Sing Chung
Replies
1
Views
248K
Hii Sing Chung
H
J
Delete extra pages in Excel 2007
  • Jo Watson
Replies
2
Views
132K
Shane Devenshire
S
I
How do I set up a function in excel to give either a <> or =?
  • ivory
Replies
3
Views
180K
ivory
I
M
SumProduct meeting two criteria
  • Mindy
Replies
4
Views
414K
Mindy
M
B
Count based on 2 conditions
  • Basenji
Replies
4
Views
473K
Basenji
B
C
Fill across worksheet pages
  • Cyara
Replies
1
Views
21K
Gary''s Student
G
J
Indirect reference causes statistical function to throw up a #NUM!
  • JoCa
Replies
10
Views
582K
Lori
L
G
I need to format a count in a pivot table
  • Golfer2100
Replies
2
Views
119K
Jason
J
M
Working on a big spreadsheet
  • mdj0615
Replies
5
Views
189K
Max
M
J
countif with AND comparing 3 columns
  • Johndb
Replies
1
Views
156K
Johndb
J
J
relative address or reference
  • James C.
Replies
1
Views
218K
T. Valko
T
J
I need to simplify this...
  • j5b9721
Replies
4
Views
23K
T. Valko
T
C
If statements
  • Cold1
Replies
2
Views
328K
Teethless mama
T
M
I know I should know this
  • mdj0615
Replies
1
Views
123K
Fred Smith
F
J
Vlookup - multiple tabs
  • jkiser
Replies
5
Views
495K
Ragdyer
R
Y
Need a Formula , please help
  • ytayta555
Replies
1
Views
187K
ytayta555
Y
M
Calculate Future Date but don't want
  • Morocco Mole
Replies
6
Views
254K
Ron Rosenfeld
R
B
Random Numbers excluding Previous Numbers
  • Brad
Replies
2
Views
103K
Jim Cone
J
B
vlookup column based on user input
  • berniean
Replies
5
Views
720K
Max
M
H
CORREL w/ condition
  • heidi
Replies
5
Views
251K
Max
M
B
Can users perform a reverse lookup
  • Blue Max
Replies
7
Views
424K
bcw_now
B
K
Function or If statement help
  • KrissyiP
Replies
1
Views
220K
Fred Smith
F
D
The date in a excel worksheet is wrong. =now() responds 1-0-1900
  • David
Replies
3
Views
25K
Ron Rosenfeld
R
J
If, then
  • Joseph
Replies
1
Views
253K
Lars-Åke Aspelin
L
N
Sum sheets based on criteria
  • npop03
Replies
5
Views
427K
Don Guillett
D
S
IF #N/A ( in a range), "ALERT","OK"
  • Steve
Replies
7
Views
428K
Steve
S
J
alternatives to embedded ifs
  • jaime_ottawa
Replies
6
Views
320K
Glenn
G
P
Function returning unexpected value
  • Paul
Replies
7
Views
185K
JoeU2004
J
K
if condition combined with SMALL
  • kaveran
Replies
3
Views
198K
Teethless mama
T
K
Copy line if
  • Kcope8302
Replies
10
Views
1M
Kcope8302
K
L
Unique values
  • LiAD
Replies
4
Views
363K
Ashish Mathur
A
M
find last populated cell in range of cells
  • Maximus
Replies
6
Views
420K
T. Valko
T
S
SUMIF criteria in different column is met?
  • spandangled
Replies
3
Views
246K
Eduardo
E
I
Help with complex "IF" formula !!!
  • Iriemon
Replies
2
Views
347K
Sam Wilson
S
L
Return date if in range, else return blank
  • LisaL
Replies
1
Views
373K
Luke M
L
I
Indirect reference
  • ice
Replies
2
Views
281K
Sam Wilson
S
F
Different twist on ISNUMBER
  • fgwiii
Replies
6
Views
139K
fgwiii
F
S
Add Range If Q
  • Seanie
Replies
1
Views
129K
Seanie
S
U
countif/sumproduct = criteria with weeknum
  • ummone
Replies
2
Views
181K
Jacob Skaria
J
K
Named Array
  • KC Excel Qns
Replies
7
Views
462K
Dana DeLouis
D
C
LOOKUP function reversed?
  • Chris
Replies
3
Views
417K
OssieMac
O
You must log in or register to post here.
Back
Top