Microsoft Excel Worksheet Functions

G
Vlookup for data contained in a cell
  • Guest
Replies
5
Views
253K
Biff
B
G
one formula to make a multiplication table work
  • Guest
Replies
3
Views
49K
Guest
G
G
Sales League table
  • Guest
Replies
1
Views
23K
Bob Phillips
B
G
ranking
  • Guest
Replies
6
Views
141K
Bob Phillips
B
G
having a two tables on the same page with different widths
  • Guest
Replies
2
Views
303K
Guest
G
S
Help with formula
  • scubagrl
Replies
1
Views
153K
BenjieLop
B
G
=max(range includes #N/As)
  • Guest
Replies
3
Views
62K
kk
K
G
vlookup reverts to data from a previous report
  • Guest
Replies
2
Views
94K
Guest
G
E
Date functions
  • excelpomoc
Replies
2
Views
148K
Guest
G
G
Locking cells after one answer
  • Guest
Replies
1
Views
136K
Don Guillett
D
G
countif
  • Guest
Replies
1
Views
60K
JE McGimpsey
J
G
Random Numbers
  • Guest
2 3
Replies
44
Views
566K
RagDyeR
R
G
Using countif with 2 conditions
  • Guest
Replies
2
Views
328K
Paul Sheppard
P
G
using linest to generate 3rd order polynomial coefficients
  • Guest
Replies
4
Views
1M
Guest
G
J
Matching data using date criteria...
  • JoeZ
Replies
1
Views
47K
JoeZ
J
B
Avoiding #NUM!
  • Bruno Campanini
Replies
9
Views
170K
Domenic
D
G
What is the shortcut key for adding $ to a cell reference eg $c$3
  • Guest
Replies
2
Views
53K
Guest
G
E
Multiple If Statements
  • excelrookie05
Replies
2
Views
162K
excelrookie05
E
G
matching numbers in col a and col b
  • Guest
Replies
1
Views
35K
Bob Phillips
B
C
numbers
  • ceemo
Replies
4
Views
111K
swatsp0p
S
G
Preceding a number by zeros, that is still a number
  • Guest
Replies
1
Views
133K
Arvi Laanemets
A
G
Fill-in empty cells from SAP report
  • Guest
Replies
3
Views
499K
Markus L
M
C
drop_down_box
  • cjjoo
Replies
1
Views
319K
Bob Phillips
B
G
Lookup question.
  • Guest
Replies
1
Views
37K
Krishnakumar
K
G
I cannot convert using HEX2DEC formula? i need a plug in i think?
  • Guest
Replies
1
Views
193K
Guest
G
S
=CONCATENATE() help!
  • shfcook
Replies
4
Views
182K
shfcook
S
G
Changing positive figures to minus figures
  • Guest
Replies
2
Views
24K
Guest
G
J
using filters with the sum function
  • justinelliott
Replies
3
Views
236K
justinelliott
J
S
finding name within range
  • sheila
Replies
4
Views
45K
sheila
S
C
Adding numbers in a single cell
  • chefcasey
Replies
1
Views
347K
Biff
B
G
Vlookup Headache
  • Guest
Replies
1
Views
35K
Biff
B
G
search value in a table and sum another column
  • Guest
Replies
3
Views
51K
kk
K
G
How do I count a value if another field = a specific value? Excel
  • Guest
Replies
3
Views
65K
Anne Troy
A
G
mixed font styles in the output of a formula?
  • Guest
Replies
1
Views
98K
Dave Peterson
D
G
SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL
  • Guest
Replies
5
Views
390K
Dave Peterson
D
P
Very Frustrating - Please Help!
  • picklevote
Replies
1
Views
209K
Ron Rosenfeld
R
J
Problem with a "if" "then" situation.
  • Jon C via OfficeKB.com
Replies
2
Views
84K
Jon C via OfficeKB.com
J
G
freeze other columns when columns have been frozen already
  • Guest
Replies
1
Views
193K
Gord Dibben
G
T
dynamic defined ranges
  • Thomas Pike
Replies
1
Views
105K
Harlan Grove
H
B
Converting CSV files into Excel files
  • baski
Replies
1
Views
70K
Anne Troy
A
G
VLOOKUP in SUMPRODUCT array
  • Guest
Replies
3
Views
792K
Domenic
D
G
I Need Help with complex formula ?
  • Guest
Replies
1
Views
293K
Anne Troy
A
C
Calculating two numbers in one cell
  • chefcasey
Replies
9
Views
685K
George Nicholson
G
G
Need to get rid of blank rows without sort
  • Guest
Replies
3
Views
152K
George Nicholson
G
G
HELP ASAP get rid of blank rows without sort
  • Guest
Replies
2
Views
124K
Harlan Grove
H
G
Retuning a column number for a specific value
  • Guest
Replies
4
Views
250K
Harlan Grove
H
G
formatting dates
  • Guest
Replies
2
Views
23K
Guest
G
G
trouble shoot pointing to a cell
  • Guest
Replies
2
Views
67K
Guest
G
G
Creation of a Generic Macro
  • Guest
Replies
1
Views
38K
Anne Troy
A
G
Please Help and Thank you!
  • Guest
Replies
1
Views
70K
Guest
G
You must log in or register to post here.
Back
Top