Microsoft Excel Worksheet Functions

Post thread
D
Change numbers in a worksheet using the $ function.
  • Davie B1
Replies
2
Views
355
Shane Devenshire
S
M
matching data to dates - please help
  • Marty
Replies
7
Views
493
Marty
M
J
Counting a Column
  • Jamakinmecrazy
Replies
7
Views
343
Shane Devenshire
S
D
look up problem
  • durbat2
Replies
3
Views
274
Shane Devenshire
S
B
IF function issues w/ empty cells
  • Bri
Replies
1
Views
345
Lars-Åke Aspelin
L
V
Calculated item - problem
  • Victorinox
Replies
3
Views
396
Victorinox
V
S
vlookup
  • shah
Replies
2
Views
298
xlm
X
M
Format Number
  • ms.maryw
Replies
3
Views
344
xlm
X
H
duplicate entries
  • HR Director
Replies
4
Views
424
Ashish Mathur
A
S
retain value and delete format
  • Solomon
Replies
6
Views
507
Max
M
L
creating formula to return one of several values
  • Lawrence
Replies
4
Views
392
Lawrence
L
J
Data Form
  • Jeff
Replies
3
Views
234
mikebres
M
C
Round to a particular tolerance
  • Chad
Replies
2
Views
459
Shane Devenshire
S
W
Ranking numbers that are a variance of 100%
  • Wicanucks
Replies
3
Views
780
Shane Devenshire
S
H
round a formula's result
  • howdylee
Replies
2
Views
524
Shane Devenshire
S
R
Complex text extraction formula
  • RhysPieces
Replies
4
Views
627
Spiky
S
R
VLOOKUP Converted to VB
  • Rod
Replies
1
Views
372
mikebres
M
P
Run macro Once
  • PR
Replies
4
Views
358
Don Guillett
D
P
Active sheet instead of a "sheet1" for Macro
  • Pantera
Replies
7
Views
728
Jarek Kujawa
J
D
Rounding time values up and down
  • durbat2
Replies
2
Views
413
Eduardo
E
F
Total cells when range is unknown
  • FirstVette52
Replies
4
Views
402
FirstVette52
F
E
Content of cell in Vlookup function
  • Ernie Fenwick
Replies
1
Views
450
Ernie Fenwick
E
S
Formulas
  • sharonrae
Replies
9
Views
487
Rick Rothstein
R
C
Formula help
  • conniefitzgerald
Replies
9
Views
444
conniefitzgerald
C
J
check and uncheck macro
  • jd64361
Replies
5
Views
1K
JE McGimpsey
J
C
Lookup - in various areas within Workbook
  • CherylH
Replies
2
Views
437
Shane Devenshire
S
N
convert bond price to decimal including +
  • novice
Replies
8
Views
27K
Rick Rothstein
R
P
Complex lookup
  • pdberger
Replies
4
Views
490
T. Valko
T
A
Return a Title based on a name
  • AccAdmin
Replies
4
Views
332
AccAdmin
A
J
Extracting text from a cell
  • jmberner
Replies
3
Views
449
Reitanos
R
S
SUMIFS Between dates that are greater than zero
  • stevencjones
Replies
1
Views
805
stevencjones
S
E
How do i find last not empty cell in a range
  • excelent
Replies
9
Views
709
Gary''s Student
G
T
Total costing
  • Tia
Replies
1
Views
471
Eduardo
E
G
Please help
  • george
Replies
1
Views
263
george
G
J
Parse Before Line Break
  • Josh O.
Replies
3
Views
436
Ashish Mathur
A
B
Sum Function w/ #DIV/0!
  • Biff
Replies
13
Views
891
Ashish Mathur
A
L
SUM 3D Reference using variable sheet limits
  • Loge
Replies
5
Views
1K
Max
M
S
Using the return from ADDRESS within another formula?
  • S Davis
Replies
5
Views
1K
S Davis
S
R
how to link format of cells
  • ramesh
Replies
1
Views
333
Shane Devenshire
S
P
Excel Iterative calculations
  • petersampson
Replies
3
Views
848
petersampson
P
L
Elegant Formulas
  • littleredhairedgirl
Replies
1
Views
398
Shane Devenshire
S
J
parsing name in cell by comma?
  • Jon M
Replies
2
Views
499
Shane Devenshire
S
S
If statement with multiple ifs
  • Sean N.
Replies
2
Views
444
Shane Devenshire
S
C
#NAME?
  • Connie Martin
Replies
6
Views
392
Shane Devenshire
S
O
Combine results of 2 formulas
  • ordnance1
Replies
2
Views
442
Shane Devenshire
S
H
working with nested vlookup formulas
  • HR Director
Replies
2
Views
449
Shane Devenshire
S
J
Using Vlookup with multiple sheet
  • Jammings
Replies
3
Views
446
T. Valko
T
P
How do I input these formulas into cells that I want written in?
  • Paige
Replies
4
Views
469
Paige
P
G
formula to find a range of cells = to a value
  • Gary
Replies
4
Views
311
Gary
G
P
Eliminating blank cells
  • PointerMan
Replies
7
Views
577
Max
M
Back
Top