Microsoft Excel Worksheet Functions

C
HLOOKUP, VLOOKUP, LOOKUP???
  • Connie Martin
Replies
10
Views
367K
Connie Martin
C
T
Formula
  • tmcwhorter
Replies
1
Views
52K
muddan madhu
M
L
basic sum with a variable twist
  • Leanne M (Aussie)
Replies
3
Views
99K
Leanne M (Aussie)
L
S
Calculating future dates using WORKDAY & specific requirements
  • seltzer
Replies
7
Views
402K
John C
J
E
Rouding to Multiple Decimals
  • Esssa
Replies
3
Views
35K
MartinW
M
A
Info function which identfies a formula
  • ArthurJ
Replies
2
Views
63K
Gary''s Student
G
L
How to check all three cells are greater than 0% and then lookup v
  • Len
Replies
7
Views
376K
Len
L
A
How to flag the items that net off each other
  • AG
Replies
3
Views
322K
AG
A
C
multiple row selecting
  • climate
Replies
3
Views
166K
Susan
S
C
Database - mulitple selection
  • Christine
Replies
1
Views
33K
Pete_UK
P
C
copying comments box
  • chesjak
Replies
1
Views
282K
Max
M
E
Using Name of worksheet in cell
  • Ernie Fenwick
Replies
2
Views
206K
Ernie Fenwick
E
E
Decimals Constant to 0.50 or Nearest Integer
  • Esssa
Replies
3
Views
450K
David Biddulph
D
S
Text String Formula Q
  • Seanie
Replies
4
Views
337K
Seanie
S
L
Copy cells from one file into another
  • Lenchik
Replies
1
Views
236K
Roger Govier
R
M
Changing Data Source on Multiple Pivot Tables at once
  • marjhan
Replies
1
Views
448K
Roger Govier
R
M
How can I copy and paste only on the unhiden cells?
  • meili
Replies
3
Views
16K
meili
M
M
Calculating Percentage of Total
  • macaskillh
Replies
3
Views
130K
ShaneDevenshire
S
T
paste without formular
  • Tracy Lo
Replies
1
Views
103K
Gord Dibben
G
J
random decimal
  • j_cotter
Replies
5
Views
91K
ShaneDevenshire
S
J
Counting unique entries in a field
  • Jeff Whitesel
Replies
5
Views
597K
JMB
J
P
Trying to get a result from 2 variables
  • PaulinaDi
Replies
3
Views
113K
ShaneDevenshire
S
H
Can I move a cell style to my quick access toolbar (Excel 07
  • hnewb
Replies
2
Views
324K
ShaneDevenshire
S
S
//time calculations
  • sansk_23
Replies
4
Views
608K
sansk_23
S
H
Improve the performance of Excel 2007.
  • Heera
Replies
1
Views
201K
ShaneDevenshire
S
D
Excel 2003 - Display precedent & dependent using shortcut
  • David
Replies
3
Views
175K
MartinW
M
M
Pictures in a database
  • Mike3502226
Replies
1
Views
58K
ShaneDevenshire
S
B
formula to automatically calculate customer age
  • bubbles galore
Replies
1
Views
254K
Max
M
V
SUMIF with date ranges
  • Vivian0102
Replies
2
Views
312K
ShaneDevenshire
S
B
Scoring Rank with Tie Breaker
  • bobdo
Replies
4
Views
539K
Pete_UK
P
C
How do I change the colour of a reoccuring word in an excel workbo
  • cutilee
Replies
8
Views
108K
Gord Dibben
G
M
Colour using If statement
  • Martin
Replies
4
Views
211K
Chip Pearson
C
G
SUMPRODUCT DUPLICATES
  • GSemler
Replies
2
Views
315K
Herbert Seidenberg
H
M
copy data from 1 cell to another.
  • Mike Reed
Replies
2
Views
289K
Spiky
S
M
Creating a template that is manually updated from another sheet.
  • MKruer
Replies
6
Views
568K
John C
J
K
Ratios
  • KCR
Replies
4
Views
287K
KCR
K
L
EXACT FUNCTION
  • Lana
Replies
10
Views
305K
Rick Rothstein
R
J
Align matching cells of two different columns
  • John Desselle
Replies
2
Views
150K
John Desselle
J
M
convert dates to month
  • Mati
Replies
6
Views
181K
Mati
M
E
insert rows in list
  • Evelyn
Replies
4
Views
105K
Evelyn
E
M
Assigning and counting values that are text
  • MikeE
Replies
8
Views
227K
Sheeloo
S
G
How do you get text to print in subtotal line?
  • Ginny
Replies
2
Views
135K
Ginny
G
J
Index returning #N/A
  • Jon Dow
Replies
5
Views
456K
Bernard Liengme
B
P
Vlookup in reverse order
  • PJFry
Replies
5
Views
50K
Chip Pearson
C
J
Percent of a Spreadsheet Complete
  • Jennifer V.
Replies
6
Views
178K
David Biddulph
D
A
vlookup between two time stamps
  • arairkar
Replies
1
Views
444K
TomPl
T
P
Conditional Sum without Range Parameters
  • Peige414
Replies
5
Views
521K
Peige414
P
G
Countif
  • Gerry Kelly
Replies
1
Views
140K
Gary''s Student
G
R
Conditional Format based on a different cell
  • Ramos
Replies
3
Views
50K
David Biddulph
D
P
How to creat a reference to a cell in another worksheet and keep f
  • PhilRobinson
Replies
5
Views
182K
Pete_UK
P
You must log in or register to post here.
Back
Top