Microsoft Excel Worksheet Functions

Post thread
J
Formula at top of excel that allows simple calculations.
  • Jerry G
Replies
2
Views
375
Shane Devenshire
S
F
Serial Number
  • Fareez
Replies
4
Views
329
Max
M
T
2003 FORMULA only plz -input in cell, chng & go to cell on otr wks
  • tlc
Replies
1
Views
617
Shane Devenshire
S
L
Count zero values before specific date
  • lesg46
Replies
6
Views
577
MBSIMON
M
F
GETPIVOTDATA returns zero when copied to another sheet
  • Frank Hayes
Replies
2
Views
888
Frank Hayes
F
W
How to write a function for column A = product of two columns, B a
  • wlfoote
Replies
4
Views
623
T. Valko
T
D
IF, but Not to Exceed
  • dnamertz
Replies
3
Views
398
Shane Devenshire
S
C
count entries that equal one criteria if another column meets anot
  • ccKennedy
Replies
7
Views
2K
Shane Devenshire
S
J
Function to Change Font
  • Jay
Replies
1
Views
285
Shane Devenshire
S
G
IRR
  • gotahavit
Replies
18
Views
1K
Ron Rosenfeld
R
R
Find In Set
  • Rod
Replies
4
Views
332
Teethless mama
T
A
Zero-Length string vs Zero (also a valid value)
  • austris.bahanovskis
Replies
2
Views
722
[email protected]
A
J
UniquifyForUser error for Essbase AddIN
  • John
Replies
1
Views
2K
Charles Williams
C
M
Subtracting partial hours
  • Melissa F
Replies
1
Views
426
T. Valko
T
J
Use of the COUNTIF function
  • JCameron
Replies
10
Views
732
Philip Mark Hunt
P
R
Some kind of Array-Sumproduct Function
  • ryguy7272
Replies
18
Views
836
Max
M
T
Extract multiple results based on multiple criteria
  • tara657
Replies
4
Views
3K
Herbert Seidenberg
H
G
Error when opening Excel workbook
  • Guest
Replies
4
Views
818
ExcelExpertUK
E
S
Age based on birthdate
  • Squid
Replies
2
Views
482
Fred Smith
F
R
function range
  • robert
Replies
1
Views
329
Joel
J
D
got a tough on and I am confused were to start
  • dlotz
Replies
3
Views
428
Joel
J
D
data validation list form sheet
  • dlotz
Replies
1
Views
319
Debra Dalgleish
D
D
drop down function
  • dlotz
Replies
2
Views
316
[email protected]
D
P
Creating drop downs for part number configuration
  • Peter
Replies
2
Views
439
Peter
P
S
Formulas change when macro adds new column
  • Sandra
Replies
3
Views
476
Ken Johnson
K
R
Function Range Lookup AGAIN!
  • robert
Replies
3
Views
407
Niek Otten
N
L
Change color of text if date is overdue
  • Lynora
Replies
2
Views
769
Lynora
L
B
Count if
  • BC
Replies
3
Views
299
BC
B
R
Function Range Lookup
  • robert
Replies
2
Views
385
T. Valko
T
Q
How do I create a FTP hyperlink in Excel
  • Qman
Replies
1
Views
3K
Gary''s Student
G
I
nested if statements using "AND" as well as "OR"
  • ibbm
Replies
2
Views
432
ibbm
I
B
If a cell is checked take words from a pivot table and place in a
  • Brian
Replies
4
Views
411
Brian
B
I
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2)
  • ItsVegas_Baby
Replies
2
Views
9K
Rick Rothstein
R
E
How can I search for a string of numeric digits within a text stri
  • Eric_NY
Replies
9
Views
483
Rick Rothstein
R
H
Reference cells in seperate worksheet
  • HR Gal
Replies
3
Views
518
Bernard Liengme
B
R
function range
  • robert
Replies
2
Views
425
Rick Rothstein
R
P
MULTIPLE CONDITIONAL FORMATS
  • Pattee
Replies
4
Views
317
Ron@Buy
R
N
sumif
  • Neil
Replies
2
Views
315
Neil
N
C
Searching for strings in a column
  • circuit_breaker
Replies
6
Views
332
Teethless mama
T
B
Deleting by date automatically
  • Bryan De-Lara
2
Replies
27
Views
995
Bryan De-Lara
B
B
Maximum Characters in a cell
  • Brosenberg7
Replies
1
Views
488
Dave Peterson
D
S
Present value of an annuity
  • sleeplessinnewjersey
Replies
4
Views
398
sleeplessinnewjersey
S
B
Find Capital Letter
  • Boogie
Replies
12
Views
688
Glenn
G
M
Date Format Problem
  • Maperalia
Replies
3
Views
235
T. Valko
T
B
text match formula not working
  • Belinda7237
Replies
2
Views
388
Belinda7237
B
J
Count function
  • John Peterson
Replies
2
Views
302
Steve
S
R
Insert rows but keep references in Excel
  • RichterCa
Replies
2
Views
367
RichterCa
R
D
Function containing $
  • Dave
Replies
2
Views
293
Mike H
M
C
Cell Formatting
  • Clare
Replies
3
Views
366
Gary''s Student
G
J
Multiple caculations using individual data
  • jschlarb
Replies
1
Views
282
Pete_UK
P
Back
Top