Microsoft Excel Worksheet Functions

Post thread
K
Averaging with #div/0! function
  • KPF
Replies
4
Views
546
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
330
b52gnav
B
M
Decimal Place Problem
  • mbgramma
Replies
1
Views
316
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
276
Frank Kabel
F
R
macro to automate procedure
  • RichardO
Replies
1
Views
399
Don Guillett
D
G
Linerar equation woes
  • Gerry
Replies
2
Views
396
Gerry
G
R
lookup?
  • Ray
Replies
3
Views
324
Frank Kabel
F
C
Something is not "right"
  • Corey872
Replies
7
Views
402
Corey872
C
G
Securing formulas
  • Guest
Replies
1
Views
303
Frank Kabel
F
A
filename in Excel
  • Are Skurdal
Replies
1
Views
261
Frank Kabel
F
S
total worked hours for a week
  • Steven
Replies
3
Views
484
Daniel.M
D
G
SumProduct with AND inside....deos not work
  • Guest
Replies
2
Views
558
Jerry W. Lewis
J
E
correct formula
  • Eamon
Replies
3
Views
359
Eamon
E
M
blank cells
  • Mike
Replies
1
Views
260
Frank Kabel
F
G
sum of values in an entire workbook
  • Guest
Replies
1
Views
363
Frank Kabel
F
S
local variables?
  • S Kutter
Replies
2
Views
255
S Kutter
S
J
Get rid of Duplicates
  • J.Robinson
Replies
1
Views
402
Guest
G
G
Index & Match versus V & H lookups
  • Guest
Replies
5
Views
541
Guest
G
A
Mutiple line display in cells that contain formulae
  • Ashok Kumar
Replies
1
Views
295
Frank Kabel
F
S
Formulas not working
  • SJBhatia
Replies
1
Views
355
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
457
Lester
L
G
Trying to count the number or customers of type x for subsequent time intervals
  • Guest
Replies
1
Views
506
Earl Kiosterud
E
G
Problem with NOW() function
  • Geuis
Replies
6
Views
369
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
314
Peo Sjoblom
P
G
IF(COUNTIF(
  • Guest
Replies
3
Views
361
Harlan Grove
H
G
Rank
  • Guest
Replies
1
Views
280
Peter Atherton
P
G
Combining IF with AND
  • Guest
Replies
1
Views
320
Frank Kabel
F
R
Excel Formula's
  • Robert
Replies
4
Views
315
Jay
J
L
microsoft excel version 6
  • Lester
Replies
2
Views
258
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
665
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
374
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
833
Sandy Mann
S
P
Problems using Excel 97 worksheet in Excel 2002
  • plfoley
Replies
1
Views
411
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
471
Frank Kabel
F
A
Trying to get a new formula
  • Armando Silva
Replies
2
Views
412
Armando Silva
A
G
In IRR period in data flow compared to period in result percentage
  • Guest
Replies
7
Views
918
Norman Harker
N
G
time difference between 2 different time values
  • Guest
Replies
2
Views
370
Guest
G
S
How can I keep "#N/A" values from appearing in VLOOKUP results?
  • shadestreet
Replies
4
Views
574
Kem
K
S
TEXT=1 formula needed
  • sonar
Replies
4
Views
268
Gord Dibben
G
G
Can't work formulas in sheets copied from the web
  • Guest
Replies
1
Views
321
Gord Dibben
G
Back
Top