Microsoft Excel Worksheet Functions

Post thread
K
Averaging with #div/0! function
  • KPF
Replies
4
Views
535
Harlan Grove
H
R
Display #N/A as 0 in VLookup
  • Ron
Replies
9
Views
895
Dave R.
D
B
Lost in Overtime Computations
  • b52gnav
Replies
2
Views
321
b52gnav
B
M
Decimal Place Problem
  • mbgramma
Replies
1
Views
313
Dave R.
D
J
Protecting multiple worksheets easily
  • Joe H.
Replies
2
Views
330
Rob
R
J
Problems with columns, macros and auto filter
  • Johan Swanepoel
Replies
2
Views
275
Frank Kabel
F
R
macro to automate procedure
  • RichardO
Replies
1
Views
394
Don Guillett
D
G
Linerar equation woes
  • Gerry
Replies
2
Views
396
Gerry
G
R
lookup?
  • Ray
Replies
3
Views
320
Frank Kabel
F
C
Something is not "right"
  • Corey872
Replies
7
Views
400
Corey872
C
G
Securing formulas
  • Guest
Replies
1
Views
302
Frank Kabel
F
A
filename in Excel
  • Are Skurdal
Replies
1
Views
260
Frank Kabel
F
S
total worked hours for a week
  • Steven
Replies
3
Views
483
Daniel.M
D
G
SumProduct with AND inside....deos not work
  • Guest
Replies
2
Views
550
Jerry W. Lewis
J
E
correct formula
  • Eamon
Replies
3
Views
355
Eamon
E
M
blank cells
  • Mike
Replies
1
Views
259
Frank Kabel
F
G
sum of values in an entire workbook
  • Guest
Replies
1
Views
362
Frank Kabel
F
S
local variables?
  • S Kutter
Replies
2
Views
252
S Kutter
S
J
Get rid of Duplicates
  • J.Robinson
Replies
1
Views
401
Guest
G
G
Index & Match versus V & H lookups
  • Guest
Replies
5
Views
523
Guest
G
A
Mutiple line display in cells that contain formulae
  • Ashok Kumar
Replies
1
Views
293
Frank Kabel
F
S
Formulas not working
  • SJBhatia
Replies
1
Views
348
Frank Kabel
F
G
Cond format a range - minimum value
  • Guest
Replies
4
Views
520
Guest
G
J
build a temp for payroll with different pay for different job
  • jessica
Replies
1
Views
447
Lester
L
G
Trying to count the number or customers of type x for subsequent time intervals
  • Guest
Replies
1
Views
501
Earl Kiosterud
E
G
Problem with NOW() function
  • Geuis
Replies
6
Views
368
Paul B
P
G
problem with formula
  • Guest
Replies
4
Views
282
Guest
G
B
Simple Macro Question !
  • Bob Vance
Replies
5
Views
308
Bob Vance
B
L
using IF & AND functions in conjunction
  • Lester
Replies
2
Views
313
Peo Sjoblom
P
G
IF(COUNTIF(
  • Guest
Replies
3
Views
360
Harlan Grove
H
G
Rank
  • Guest
Replies
1
Views
275
Peter Atherton
P
G
Combining IF with AND
  • Guest
Replies
1
Views
319
Frank Kabel
F
R
Excel Formula's
  • Robert
Replies
4
Views
315
Jay
J
L
microsoft excel version 6
  • Lester
Replies
2
Views
257
Harald Staff
H
S
Prevent access to macro's if sheet is password protected
  • sonar
Replies
3
Views
1K
JE McGimpsey
J
K
Sorting in numerical order when numbers and alphas are used
  • Katherine
Replies
2
Views
655
Earl Kiosterud
E
S
=If(text)=1,0) - approximate format required that works
  • sonar
Replies
5
Views
488
Rob
R
S
Reference cell in Active Window-possible?
  • Simon
Replies
4
Views
363
Bob Phillips
B
R
Making CurrentRow a lot 'clearer'
  • Rasmus
Replies
3
Views
405
Paul B
P
G
sound activation
  • Gil
Replies
1
Views
285
Frank Kabel
F
P
Dividing function: can you define the decimal place?
  • PhoebeB
Replies
4
Views
830
Sandy Mann
S
P
Problems using Excel 97 worksheet in Excel 2002
  • plfoley
Replies
1
Views
403
Harlan Grove
H
G
how to do conditional formating for a row
  • Guest
Replies
2
Views
269
JE McGimpsey
J
J
I need to activate a cell within a macro and am having difficulty
  • Jeff Smith
Replies
3
Views
456
Frank Kabel
F
A
Trying to get a new formula
  • Armando Silva
Replies
2
Views
389
Armando Silva
A
G
In IRR period in data flow compared to period in result percentage
  • Guest
Replies
7
Views
914
Norman Harker
N
G
time difference between 2 different time values
  • Guest
Replies
2
Views
364
Guest
G
S
How can I keep "#N/A" values from appearing in VLOOKUP results?
  • shadestreet
Replies
4
Views
570
Kem
K
S
TEXT=1 formula needed
  • sonar
Replies
4
Views
256
Gord Dibben
G
G
Can't work formulas in sheets copied from the web
  • Guest
Replies
1
Views
313
Gord Dibben
G
Back
Top