Microsoft Excel Worksheet Functions

Post thread
S
#Missing
  • Shirley
Replies
1
Views
865
JLatham
J
J
similar names - two spreadsheets
  • jtkuehn
Replies
3
Views
388
dan dungan
D
X
Choose 2 of 6 optional units for grade - formula question
  • xtrailer
Replies
1
Views
342
dan dungan
D
7
=SUMPRODUCT Col E = B, Col F = blank
  • 77Debbie77
Replies
7
Views
615
Dave Peterson
D
A
how do I apply formatting from one worksheet to a whole workbook?
  • amergerm35
Replies
5
Views
548
amergerm35
A
L
hyperlink to other sw(exe) and open with parameters
  • L@ja
Replies
2
Views
643
ShaneDevenshire
S
E
weighted average
  • elaine9412
Replies
6
Views
456
Duke Carey
D
7
#NAME?
  • 77Debbie77
Replies
5
Views
400
77Debbie77
7
E
URGENT! how count how often a vlaue occurs within a range of value
  • elaine9412
Replies
3
Views
433
T. Valko
T
K
Finding last cell with a value and then adding to another
  • KoolyHigh
Replies
2
Views
519
KoolyHigh
K
C
If formula with two conditions to meet
  • Carolina
Replies
7
Views
530
Carolina
C
C
splitting and formating a number series into date/time
  • CMG8401
Replies
3
Views
346
Pete_UK
P
A
"move tab sheets"
  • Avinono1
Replies
1
Views
279
Pete_UK
P
B
amortization schedule / Mortgage payments
  • Bmac
Replies
5
Views
1K
Bernie Deitrick
B
T
Complex SUMPRODUCT/VLOOKUP/SUMIF
  • tigger
Replies
1
Views
833
tigger
T
S
how do i do interest roll up calculation in excel
  • Steve Costello
Replies
1
Views
4K
Spiky
S
J
How to restrict user to input only one of multiple cells
  • James
Replies
1
Views
408
Gary''s Student
G
S
IF question
  • Stuart
Replies
2
Views
282
Stuart
S
W
Calculation of an UDF
  • Werner Rohrmoser
Replies
5
Views
501
Werner Rohrmoser
W
P
Keep all cells in a column unique? No cells identical
  • phillr
Replies
1
Views
455
Gary''s Student
G
C
NEED INFO to the left of rqd cell
  • CAPTGNVR
Replies
7
Views
389
CAPTGNVR
C
B
match with isna formula question
  • Belinda7237
Replies
2
Views
565
Belinda7237
B
D
add If to formula to blank #n/a
  • Diddy
Replies
3
Views
411
Max
M
R
=SUMPRODUCT(--(TRIM(A1:A10)<>"")), what does the "--" mean?
  • Ray
Replies
1
Views
704
T. Valko
T
T
Active Cell Color
  • Taurien
Replies
5
Views
402
Taurien
T
S
Simple IF , maybe, for names in columns
  • Steve
Replies
7
Views
380
Max
M
S
How do I set a static date?
  • Shawn
Replies
5
Views
428
Dave Peterson
D
S
Multiple "IF"'s
  • Solar Man
Replies
5
Views
329
Solar Man
S
D
Convert to Binary and Break out results
  • DCLittlejohn
Replies
10
Views
628
Rick Rothstein \(MVP - VB\)
R
P
Non-Array Play to Eliminate Blank Cells
  • Peter
Replies
5
Views
525
Peter
P
S
nesting sumproduct with subtotal
  • SteveDB1
Replies
9
Views
2K
SteveDB1
S
D
Basing a range for a linked spreadsheet on internal criteria
  • dstampor
Replies
6
Views
365
dstampor
D
A
Replace Link
  • Annette
Replies
5
Views
268
Dave Peterson
D
K
Worksheet calculation different from calculator's
  • KARTX
Replies
9
Views
407
T. Valko
T
A
Conditional format row based on percentile
  • Acanesfan
Replies
3
Views
595
Spiky
S
R
What are the COUNT or other options ...
  • rugbykats
Replies
3
Views
325
rugbykats
R
V
Average
  • Vercingetorix.XIII
Replies
9
Views
456
Bob Bridges
B
E
VLOOKUP and "-" characters
  • Exxet
Replies
4
Views
616
Exxet
E
R
Multiple IF Formula Question
  • Rob
Replies
5
Views
257
Rob
R
D
what formula can i use to find a specific value?
  • dan dungan
Replies
1
Views
460
dan dungan
D
M
SUMIFS including hidden rows
  • moosie
Replies
1
Views
673
Bob Phillips
B
S
Searching A List
  • smartin
Replies
1
Views
228
smartin
S
H
Calling Bernie Deitrick
  • Hile
Replies
4
Views
443
Hile
H
N
Finding a calculated Value across Columns
  • Nigel Wallis
Replies
2
Views
386
Nigel Wallis
N
C
Hyperlink link_location error
  • Cynthia Haggerty
Replies
15
Views
668
Cynthia Haggerty
C
G
Just a bad day in Excel
  • Geiss-Evans
Replies
2
Views
271
ryguy7272
R
D
IF and Then Formula Help Needed Please
  • Dimple
Replies
5
Views
357
Dimple
D
R
Call Center Talk Times
  • Randy Rich
Replies
12
Views
575
ward376
W
N
How to extract capitalized group in text string
  • newbie
Replies
9
Views
792
Ron Rosenfeld
R
D
Pivot Table Design
  • dss
Replies
1
Views
281
Spiky
S
Back
Top