Microsoft Excel Worksheet Functions

K
Averaging with #div/0! function
  • KPF
Replies
4
Views
134K
Harlan Grove
H
R
Display #N/A as 0 in VLookup
  • Ron
Replies
9
Views
225K
Dave R.
D
B
Lost in Overtime Computations
  • b52gnav
Replies
2
Views
94K
b52gnav
B
M
Decimal Place Problem
  • mbgramma
Replies
1
Views
63K
Dave R.
D
J
Protecting multiple worksheets easily
  • Joe H.
Replies
2
Views
92K
Rob
R
J
Problems with columns, macros and auto filter
  • Johan Swanepoel
Replies
2
Views
62K
Frank Kabel
F
R
macro to automate procedure
  • RichardO
Replies
1
Views
51K
Don Guillett
D
G
Linerar equation woes
  • Gerry
Replies
2
Views
57K
Gerry
G
R
lookup?
  • Ray
Replies
3
Views
52K
Frank Kabel
F
C
Something is not "right"
  • Corey872
Replies
7
Views
87K
Corey872
C
G
Securing formulas
  • Guest
Replies
1
Views
94K
Frank Kabel
F
A
filename in Excel
  • Are Skurdal
Replies
1
Views
26K
Frank Kabel
F
S
total worked hours for a week
  • Steven
Replies
3
Views
113K
Daniel.M
D
G
SumProduct with AND inside....deos not work
  • Guest
Replies
2
Views
91K
Jerry W. Lewis
J
E
correct formula
  • Eamon
Replies
3
Views
79K
Eamon
E
M
blank cells
  • Mike
Replies
1
Views
55K
Frank Kabel
F
G
sum of values in an entire workbook
  • Guest
Replies
1
Views
16K
Frank Kabel
F
S
local variables?
  • S Kutter
Replies
2
Views
70K
S Kutter
S
J
Get rid of Duplicates
  • J.Robinson
Replies
1
Views
80K
Guest
G
G
Index & Match versus V & H lookups
  • Guest
Replies
5
Views
169K
Guest
G
A
Mutiple line display in cells that contain formulae
  • Ashok Kumar
Replies
1
Views
44K
Frank Kabel
F
S
Formulas not working
  • SJBhatia
Replies
1
Views
89K
Frank Kabel
F
G
Cond format a range - minimum value
  • Guest
Replies
4
Views
71K
Guest
G
J
build a temp for payroll with different pay for different job
  • jessica
Replies
1
Views
218K
Lester
L
G
Trying to count the number or customers of type x for subsequent time intervals
  • Guest
Replies
1
Views
256K
Earl Kiosterud
E
G
Problem with NOW() function
  • Geuis
Replies
6
Views
148K
Paul B
P
G
problem with formula
  • Guest
Replies
4
Views
117K
Guest
G
B
Simple Macro Question !
  • Bob Vance
Replies
5
Views
40K
Bob Vance
B
L
using IF & AND functions in conjunction
  • Lester
Replies
2
Views
49K
Peo Sjoblom
P
G
IF(COUNTIF(
  • Guest
Replies
3
Views
46K
Harlan Grove
H
G
Rank
  • Guest
Replies
1
Views
68K
Peter Atherton
P
G
Combining IF with AND
  • Guest
Replies
1
Views
21K
Frank Kabel
F
R
Excel Formula's
  • Robert
Replies
4
Views
100K
Jay
J
L
microsoft excel version 6
  • Lester
Replies
2
Views
176K
Harald Staff
H
S
Prevent access to macro's if sheet is password protected
  • sonar
Replies
3
Views
202K
JE McGimpsey
J
K
Sorting in numerical order when numbers and alphas are used
  • Katherine
Replies
2
Views
438K
Earl Kiosterud
E
S
=If(text)=1,0) - approximate format required that works
  • sonar
Replies
5
Views
131K
Rob
R
S
Reference cell in Active Window-possible?
  • Simon
Replies
4
Views
156K
Bob Phillips
B
R
Making CurrentRow a lot 'clearer'
  • Rasmus
Replies
3
Views
102K
Paul B
P
G
sound activation
  • Gil
Replies
1
Views
54K
Frank Kabel
F
P
Dividing function: can you define the decimal place?
  • PhoebeB
Replies
4
Views
169K
Sandy Mann
S
P
Problems using Excel 97 worksheet in Excel 2002
  • plfoley
Replies
1
Views
75K
Harlan Grove
H
G
how to do conditional formating for a row
  • Guest
Replies
2
Views
118K
JE McGimpsey
J
J
I need to activate a cell within a macro and am having difficulty
  • Jeff Smith
Replies
3
Views
110K
Frank Kabel
F
A
Trying to get a new formula
  • Armando Silva
Replies
2
Views
245K
Armando Silva
A
G
In IRR period in data flow compared to period in result percentage
  • Guest
Replies
7
Views
266K
Norman Harker
N
G
time difference between 2 different time values
  • Guest
Replies
2
Views
136K
Guest
G
S
How can I keep "#N/A" values from appearing in VLOOKUP results?
  • shadestreet
Replies
4
Views
174K
Kem
K
S
TEXT=1 formula needed
  • sonar
Replies
4
Views
282K
Gord Dibben
G
G
Can't work formulas in sheets copied from the web
  • Guest
Replies
1
Views
40K
Gord Dibben
G
You must log in or register to post here.
Back
Top