Microsoft Excel Worksheet Functions

Post thread
A
vlookup in the row below the target row
  • AG
Replies
2
Views
1K
AG
A
S
Cell insertion if values not matching
  • Susan
Replies
2
Views
357
Susan
S
S
REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA
  • Security Dave
Replies
4
Views
3K
David Biddulph
D
V
Alternative formula to the vlookup formula?
  • Victor
Replies
2
Views
896
Victor
V
B
Returning Yesterday
  • bollard
Replies
5
Views
411
bollard
B
C
Tabbing to select fields
  • Confused
Replies
2
Views
274
Confused
C
B
Mulitiple functions in one cell
  • Bob Phillips
Replies
1
Views
338
cgroninger
C
L
Sum of unique values within a range with blank cells
  • loook
Replies
3
Views
496
Teethless mama
T
L
Formula only works on some computers
  • Libby
Replies
13
Views
860
Bob Phillips
B
R
Adding numbers to text!
  • Rocketeer
Replies
4
Views
404
Max
M
R
Help on how to use the PARETOINV function!
  • Rocketeer
Replies
2
Views
313
Rocketeer
R
S
formula for 2% annual sales increases
  • shepzuck
Replies
4
Views
399
shepzuck
S
T
Calculating a sum from a given number of rows
  • tunupo
Replies
3
Views
573
tunupo
T
K
How do I format cells to show date in Australian not US format?
  • Kevin B
Replies
1
Views
570
Fred Smith
F
J
Find Smallest entry but excluding zero
  • jambun
Replies
4
Views
490
[email protected]
J
K
Comparing sets of data, where criteria met, sum certain columns.
  • Kimberly
Replies
6
Views
605
Kimberly
K
P
Calender function - time sheet - excel 2003/7
  • Peter Balcombe
Replies
3
Views
587
Rick Rothstein \(MVP - VB\)
R
L
formatting in different countries
  • Libby
Replies
5
Views
553
Rick Rothstein \(MVP - VB\)
R
M
how i convert "100" to "hundred"( number to text) in excel-2007
  • mohanraj
Replies
1
Views
7K
Niek Otten
N
M
HELP!!
  • Mac
Replies
10
Views
460
mac
M
I
move cursor on limited cells.
  • Invisible
Replies
1
Views
409
Gary''s Student
G
M
pay slips
  • michael
Replies
3
Views
9K
Don Guillett
D
S
LookUp to Display Last Value Populated a in Range
  • sony654
Replies
13
Views
828
sony654
S
B
Move text
  • bgkgmg
Replies
1
Views
406
Pete_UK
P
R
Excel - Formulae across several sheets
  • Realoldchipguy
Replies
2
Views
538
Realoldchipguy
R
J
IF Function formula
  • Jennifer
Replies
3
Views
353
Bob Phillips
B
T
How do I ingnore non-numeric cells in Analysis toolpak?
  • toloughlin
Replies
2
Views
4K
toloughlin
T
G
Formula Funtions
  • Garyp1961
Replies
7
Views
537
Garyp1961
G
R
3 variable lookup
  • rooter
Replies
6
Views
492
T. Valko
T
P
custom views troubleshoot
  • pb
Replies
1
Views
368
Gord Dibben
G
M
scroll lock
  • moiz
Replies
9
Views
1K
Gord Dibben
G
M
Need formula
  • Mrtvac
Replies
2
Views
298
Gord Dibben
G
D
day increasing by 1 when i drag and drop
  • dencara
Replies
4
Views
363
Gord Dibben
G
H
Muti-page workbook highlight specific dates that occur throughout
  • hamilton_heff
Replies
1
Views
285
Rick Rothstein \(MVP - VB\)
R
K
multiple if statements
  • Kwray
Replies
4
Views
539
Kwray
K
C
Function to calculate total hours worked in one week.
  • cahabbinga
Replies
4
Views
902
cahabbinga
C
A
Conditional Result based on Multiple Columns
  • AnnArborBrian
Replies
6
Views
496
AnnArborBrian
A
A
when I type 1 it is displayed as 0.01
  • Amarjeet
Replies
1
Views
544
Gary''s Student
G
S
Danish Question HÆLDNING
  • Stefan DK
Replies
2
Views
231
Stefan DK
S
W
How do i make one cell get just the row amount from another cell?
  • Wuggles
Replies
3
Views
487
Pete_UK
P
C
checking for Match
  • Craig
Replies
2
Views
421
Craig
C
R
VLOOKUP using 2 Cells
  • RoadKill
Replies
3
Views
269
Max
M
D
Format Name
  • Dax Arroway
Replies
6
Views
540
Rick Rothstein \(MVP - VB\)
R
D
Cell Format - What's wrong?
  • Danny
Replies
6
Views
470
Danny
D
M
creating sub worksheets
  • Manny M
Replies
1
Views
464
Dave Peterson
D
G
How to remove duplicated data repeated in a column and keep just o
  • Guest
Replies
5
Views
467
pea
P
C
date ranges
  • Carolina Girl
Replies
3
Views
386
T. Valko
T
M
select multiple records in database given conditions
  • MayFestivalRon
Replies
1
Views
291
Dave Peterson
D
F
Using Sumif On Two Columns of Data - How?
  • f252863
Replies
3
Views
392
Mike H
M
D
vlookup and Sum unique values
  • Diggsy
Replies
2
Views
477
Mike H
M
Back
Top