Microsoft Excel Worksheet Functions

F
Serial Number
  • Fareez
Replies
4
Views
52K
Max
M
T
2003 FORMULA only plz -input in cell, chng & go to cell on otr wks
  • tlc
Replies
1
Views
326K
Shane Devenshire
S
L
Count zero values before specific date
  • lesg46
Replies
6
Views
567K
MBSIMON
M
F
GETPIVOTDATA returns zero when copied to another sheet
  • Frank Hayes
Replies
2
Views
200K
Frank Hayes
F
W
How to write a function for column A = product of two columns, B a
  • wlfoote
Replies
4
Views
279K
T. Valko
T
D
IF, but Not to Exceed
  • dnamertz
Replies
3
Views
292K
Shane Devenshire
S
C
count entries that equal one criteria if another column meets anot
  • ccKennedy
Replies
7
Views
409K
Shane Devenshire
S
J
Function to Change Font
  • Jay
Replies
1
Views
109K
Shane Devenshire
S
G
IRR
  • gotahavit
Replies
18
Views
1M
Ron Rosenfeld
R
R
Find In Set
  • Rod
Replies
4
Views
14K
Teethless mama
T
A
Zero-Length string vs Zero (also a valid value)
  • austris.bahanovskis
Replies
2
Views
250K
[email protected]
A
J
UniquifyForUser error for Essbase AddIN
  • John
Replies
1
Views
299K
Charles Williams
C
M
Subtracting partial hours
  • Melissa F
Replies
1
Views
199K
T. Valko
T
J
Use of the COUNTIF function
  • JCameron
Replies
10
Views
537K
Philip Mark Hunt
P
R
Some kind of Array-Sumproduct Function
  • ryguy7272
Replies
18
Views
705K
Max
M
T
Extract multiple results based on multiple criteria
  • tara657
Replies
4
Views
395K
Herbert Seidenberg
H
G
Error when opening Excel workbook
  • Guest
Replies
4
Views
28K
ExcelExpertUK
E
S
Age based on birthdate
  • Squid
Replies
2
Views
376K
Fred Smith
F
R
function range
  • robert
Replies
1
Views
386K
Joel
J
D
got a tough on and I am confused were to start
  • dlotz
Replies
3
Views
438K
Joel
J
D
data validation list form sheet
  • dlotz
Replies
1
Views
94K
Debra Dalgleish
D
D
drop down function
  • dlotz
Replies
2
Views
13K
[email protected]
D
P
Creating drop downs for part number configuration
  • Peter
Replies
2
Views
117K
Peter
P
S
Formulas change when macro adds new column
  • Sandra
Replies
3
Views
101K
Ken Johnson
K
R
Function Range Lookup AGAIN!
  • robert
Replies
3
Views
343K
Niek Otten
N
L
Change color of text if date is overdue
  • Lynora
Replies
2
Views
31K
Lynora
L
B
Count if
  • BC
Replies
3
Views
292K
BC
B
R
Function Range Lookup
  • robert
Replies
2
Views
348K
T. Valko
T
Q
How do I create a FTP hyperlink in Excel
  • Qman
Replies
1
Views
166K
Gary''s Student
G
I
nested if statements using "AND" as well as "OR"
  • ibbm
Replies
2
Views
193K
ibbm
I
B
If a cell is checked take words from a pivot table and place in a
  • Brian
Replies
4
Views
308K
Brian
B
I
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2)
  • ItsVegas_Baby
Replies
2
Views
344K
Rick Rothstein
R
E
How can I search for a string of numeric digits within a text stri
  • Eric_NY
Replies
9
Views
438K
Rick Rothstein
R
H
Reference cells in seperate worksheet
  • HR Gal
Replies
3
Views
423K
Bernard Liengme
B
R
function range
  • robert
Replies
2
Views
287K
Rick Rothstein
R
P
MULTIPLE CONDITIONAL FORMATS
  • Pattee
Replies
4
Views
14K
Ron@Buy
R
N
sumif
  • Neil
Replies
2
Views
99K
Neil
N
C
Searching for strings in a column
  • circuit_breaker
Replies
6
Views
572K
Teethless mama
T
B
Deleting by date automatically
  • Bryan De-Lara
2
Replies
27
Views
1M
Bryan De-Lara
B
B
Maximum Characters in a cell
  • Brosenberg7
Replies
1
Views
160K
Dave Peterson
D
S
Present value of an annuity
  • sleeplessinnewjersey
Replies
4
Views
45K
sleeplessinnewjersey
S
B
Find Capital Letter
  • Boogie
Replies
12
Views
622K
Glenn
G
M
Date Format Problem
  • Maperalia
Replies
3
Views
150K
T. Valko
T
B
text match formula not working
  • Belinda7237
Replies
2
Views
447K
Belinda7237
B
J
Count function
  • John Peterson
Replies
2
Views
234K
Steve
S
R
Insert rows but keep references in Excel
  • RichterCa
Replies
2
Views
235K
RichterCa
R
D
Function containing $
  • Dave
Replies
2
Views
49K
Mike H
M
C
Cell Formatting
  • Clare
Replies
3
Views
147K
Gary''s Student
G
J
Multiple caculations using individual data
  • jschlarb
Replies
1
Views
186K
Pete_UK
P
T
SUMPRODUCT query
  • Terry Bennett
Replies
3
Views
268K
Terry Bennett
T
You must log in or register to post here.
Back
Top