Microsoft Excel Worksheet Functions

I
Vlookup and "value"
  • ican
Replies
1
Views
275K
T. Valko
T
B
Counting totals between multiple columns for like items
  • Bernie R.
Replies
9
Views
469K
T. Valko
T
D
nested IF - too many arguements.
  • Dave
Replies
2
Views
340K
Tyro
T
B
IF formula:enter value if it occured in the year 2008,otherwise 0
  • Barbora
Replies
1
Views
117K
Tyro
T
J
how do I turn off the insert function dialog box in excel formulas
  • Judy B from Lake Erie
Replies
2
Views
369K
MartinW
M
F
Conditional Formating based on Date
  • Flcnmech
Replies
1
Views
260K
David Biddulph
D
J
aconcat UDF throwing a #NAME error
  • Josh Rogers
Replies
10
Views
721K
Josh Rogers
J
F
frequency function with decimals
  • frequency function with decimals
Replies
2
Views
177K
Teethless mama
T
T
Countif and dates
  • Tom
Replies
4
Views
129K
Dave Peterson
D
P
Absolute References (Excel 97)
  • Phendrena
Replies
1
Views
54K
Phendrena
P
N
SUMIF and #VALUE! when source is closed?
  • NeedToKnow
Replies
4
Views
267K
JLatham
J
E
Nesting countif functions
  • Evan
Replies
1
Views
207K
Rick Rothstein \(MVP - VB\)
R
M
Discounted Value of money
  • Murthy
Replies
5
Views
301K
joeu2004
J
T
count the occurrences of a month in a date&time cell
  • Tom
Replies
6
Views
556K
Tom
T
M
Date
  • Mike
Replies
1
Views
138K
Sandy Mann
S
B
How do I do conditional validation in excel?
  • Barry
Replies
2
Views
87K
Barry
B
N
calculating IRR
  • naffyb
Replies
2
Views
299K
[email protected]
J
S
Search for Text within a Formula Result Q
  • Sean
Replies
5
Views
399K
Ron Rosenfeld
R
B
Deriving an earlier date based on a later date
  • Bob
Replies
7
Views
677K
Ron Rosenfeld
R
4
How do I set up an Excel workbook to convert GMT to EST?
  • 49 forever
Replies
4
Views
437K
Ron Rosenfeld
R
B
MSN Stock Quotes Addin fails to update
  • bryan
Replies
1
Views
135K
[email protected]
B
L
Excel date conversion-UK to US
  • lainy
Replies
1
Views
355K
Bob Phillips
B
P
Data Extraction (Excel 97)
  • Phendrena
Replies
6
Views
488K
Phendrena
P
D
Help with defining names
  • devproduct
Replies
3
Views
327K
David Biddulph
D
J
Runtime Error '-2147352565 (8002000b)'
  • JohnQ
Replies
1
Views
644K
Ron@Buy
R
S
Express 'Joined up' IF's Q
  • Sean
Replies
7
Views
788K
Sean
S
R
Linking two "tables" of data.
  • Regnab
Replies
6
Views
488K
Regnab
R
N
Date & Time Stamp for printing
  • Neon520
Replies
1
Views
416K
Gord Dibben
G
S
How do I enter a new row every 12 rows in a very large spreadsheet
  • Sarah
Replies
3
Views
184K
Jim Cone
J
C
Date function
  • Charles
Replies
3
Views
188K
Tyro
T
B
how can you average subtotals of visible cells only?
  • Bear Black
Replies
1
Views
304K
JP
J
B
How do I insert the same field twice in an Excel 2007 pivot table
  • burtgard
Replies
1
Views
251K
Fred Smith
F
J
Why doesn't RANK(1,{2,1}) work?
  • joeu2004
Replies
2
Views
172K
joeu2004
J
W
replace dash in a number sequence
  • Willy Wonka
Replies
1
Views
147K
Gary''s Student
G
S
look up latest entry in a series?
  • sschmerl
Replies
1
Views
130K
Pete_UK
P
A
FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT
  • armymatt
Replies
2
Views
128K
armymatt
A
D
Excel 2003: I need the Drop-Down List symbol to show all the time
  • Doingthat2
Replies
1
Views
195K
T. Valko
T
S
Using the If() Function for a percentage range
  • season
Replies
3
Views
173K
Tyro
T
K
grouping dates in pivot table: calculated field?
  • katy
Replies
2
Views
442K
katy
K
N
Cut & Paste Conditional Formatting
  • Neon520
Replies
1
Views
239K
Neon520
N
P
If Statement
  • ppidgursky
Replies
19
Views
618K
Don Guillett
D
M
date + 6 months
  • myfairlight97-precisiontv
Replies
3
Views
185K
David Biddulph
D
A
Insert lines in a cell
  • Angie
Replies
2
Views
215K
Meebers
M
B
excel formula
  • bronxbabe
Replies
17
Views
407K
Meenie
M
M
Divide in Excel 2000
  • Mike
Replies
1
Views
104K
T. Valko
T
J
Counting Days Between Dates
  • JerryS
Replies
1
Views
315K
Niek Otten
N
J
Multiple SUMIF criteria
  • jxbeeman
Replies
1
Views
306K
Mike H
M
V
"Make text continue from worksheet 1 onto worksheet 2"
  • Vegas Van
Replies
4
Views
138K
Dave Peterson
D
B
how do i split an excel spreadsheet into 6 panes?
  • Baigi
Replies
4
Views
383K
BIG D
B
H
list of unique elements
  • Helena
Replies
5
Views
187K
T. Valko
T
You must log in or register to post here.
Back
Top