Microsoft Excel Worksheet Functions

C
Pulling matching data from separate worksheets
  • Coquette
Replies
3
Views
108K
Bernie Deitrick
B
A
Swapping cells data
  • Andy P
Replies
1
Views
51K
Frank Kabel
F
L
bitwise XOR calc
  • Luke
Replies
1
Views
154K
Frank Kabel
F
M
Average IF Help
  • Mike
Replies
4
Views
294K
Mike
M
L
Sorting data with formulas
  • Laura
Replies
2
Views
64K
Bernd
B
V
Multiple Lookup Value in VLOOKUP ?
  • Vinns
Replies
2
Views
34K
vinns
V
D
Automatic sorting of data
  • dansargeant
Replies
2
Views
80K
Bernd
B
L
If cell = 0
  • Lance
Replies
2
Views
129K
Frank Kabel
F
W
Cell Active as argument..... IS IT IMPOSSIBLE?
  • WalterNavarroG
Replies
1
Views
26K
Frank Kabel
F
G
Excel should let me "sort" worksheets - especially useful when ha.
  • Guest
Replies
1
Views
33K
Frank Kabel
F
G
In Excel create index on first sheet of selected worksheets
  • Guest
Replies
1
Views
69K
Frank Kabel
F
X
Summing lookups?
  • Xabu
Replies
6
Views
66K
Xabu
X
G
function to split figure into 500k, 200k and 100k
  • Guest
Replies
4
Views
66K
Guest
G
N
GETPIVOTDATA if column doesn't exist
  • neotokyo
Replies
1
Views
177K
Debra Dalgleish
D
J
Vlookup
  • Jose
Replies
4
Views
29K
Myrna Larson
M
J
Combining Two Similar Lists?
  • Jeff
Replies
6
Views
49K
Max
M
G
calculate a grade point average
  • Guest
Replies
1
Views
68K
Vasant Nanavati
V
G
Date searching TRUE/FALSE
  • Guest
Replies
4
Views
83K
Guest
G
T
Average If
  • tomandrobyn
Replies
6
Views
173K
Jerry W. Lewis
J
J
Excel Formulas
  • Jeff
Replies
1
Views
99K
Jeff
J
G
compare values
  • Guest
Replies
1
Views
67K
Andy Brown
A
S
Nested VLOOKUP within IF Statement
  • Sbrotz
Replies
1
Views
35K
Peo Sjoblom
P
D
count between dates
  • Doug Loewen
Replies
2
Views
43K
Ron Rosenfeld
R
A
Replace #DIV/0 error?
  • Alan
Replies
1
Views
156K
Frank Kabel
F
J
Need help with a formula
  • johnsonbp
Replies
3
Views
116K
JE McGimpsey
J
E
convert units of measure - feet to inches
  • Eamon
Replies
3
Views
482K
Eamon
E
B
Excel page breaks
  • Bill
Replies
3
Views
191K
Guest
G
G
Search,Index,Match help
  • GerryK
Replies
6
Views
31K
GerryK
G
G
Compare two similar files
  • Gizmo
Replies
4
Views
65K
Gizmo
G
E
Excel database capability
  • Elle
Replies
2
Views
92K
Guest
G
C
COUNTIF
  • Connie
Replies
4
Views
124K
Connie
C
F
How many minutes to clean a room
  • FB
Replies
3
Views
137K
Sandy Mann
S
K
sum if
  • kieran
Replies
1
Views
283K
Frank Kabel
F
C
Can I conditionally UNLOCK a cell?
  • Chris
Replies
1
Views
129K
Frank Kabel
F
R
unable to open Macro "library"
  • Roger
Replies
6
Views
117K
Frank Kabel
F
G
Link Cell to header and footer
  • Guest
Replies
1
Views
64K
Frank Kabel
F
C
count rows that match conditional formatting
  • Carole
Replies
1
Views
60K
Frank Kabel
F
P
Include IF in formula
  • Pat
Replies
18
Views
503K
RagDyer
R
J
How to perform an automated AutoFilter sort
  • Jeff Smith
Replies
9
Views
187K
jeradklingen
J
B
separating names into 2 columns
  • bagia
Replies
2
Views
52K
bagia
B
J
Comparing Strings with <
  • Jonathan Rynd
Replies
3
Views
152K
hgrove
H
C
count of rows that match conditional formatting
  • Carole
Replies
2
Views
84K
Carole
C
G
How do I make 'CSCO" in this formula a variable? =ilx|Q!'CSCO,open
  • Gary Thomson
Replies
1
Views
50K
Jonathan Rynd
J
C
Statistical formulas
  • cparaske
Replies
3
Views
111K
cparaske
C
D
Random Number for Drawing
  • Dan Tschippert
Replies
5
Views
419K
Bernie Deitrick
B
G
Excel 2003 list command not available
  • Guest
Replies
2
Views
61K
JulieD
J
N
Maximum amount of lines
  • Newbie
Replies
1
Views
32K
Guest
G
T
Indirect Function ???
  • Tony
Replies
2
Views
138K
Gary Thomson
G
S
cut and paste cell reference problems
  • ssibert
Replies
2
Views
90K
ssibert
S
B
Can't type on existing document
  • Bob
Replies
2
Views
64K
Guest
G
You must log in or register to post here.
Back
Top