Microsoft Excel Worksheet Functions

S
Right function to use
  • SHelley
Replies
3
Views
256K
Bob Phillips
B
V
fill data across worksheets
  • VBL
Replies
1
Views
191K
art
A
K
Calculate number of Mondays betweeb 2 dates
  • k.roberts
Replies
6
Views
453K
Roger Govier
R
M
Calculate a Date
  • Mac55
Replies
6
Views
604K
Shane Devenshire
S
A
Workdays
  • Andrew
Replies
3
Views
375K
Shane Devenshire
S
S
working with multiple consolidation ranges.
  • Saraladevi
Replies
1
Views
182K
Shane Devenshire
S
S
Information match formula
  • scott
Replies
2
Views
228K
Shane Devenshire
S
A
Excel Function Question??
  • akemeny
Replies
11
Views
835K
akemeny
A
R
How to I sum data from one sheet based off mulitple variables?
  • Rachel S.
Replies
7
Views
548K
Bob Phillips
B
J
Making a date go red, if date passes todays date.
  • Jamie
Replies
2
Views
84K
Bob Phillips
B
S
converting numbers
  • sevy
Replies
5
Views
377K
Lori
L
V
Text to Columns wizard greyed out
  • vic1
Replies
4
Views
2M
vic1
V
L
Filter Data using a drop-down list
  • Lboom2008
Replies
2
Views
189K
Lboom2008
L
A
Formula between sheets.
  • AB Lighting
Replies
3
Views
266K
Roger Govier
R
S
If Array EDATE formula help
  • SCrowley
Replies
7
Views
623K
T. Valko
T
E
Time Format Help Needed (Excel)
  • Erin
Replies
3
Views
558K
Peo Sjoblom
P
S
Auto Numbering Test Scores and want ties to count the same
  • Scott
Replies
3
Views
278K
T. Valko
T
H
Mix/Max/Avg Help based on dynamic ranges
  • Hile
Replies
16
Views
1M
T. Valko
T
A
how can I start and stop a sum formula?
  • Ang
Replies
1
Views
147K
T. Valko
T
K
sums of range within sumproduct
  • Kayce
Replies
4
Views
556K
Kayce
K
K
360-day Year Based Payment & Amortization Calculations?
  • Kelley from NC
Replies
1
Views
349K
Fred Smith
F
T
How do I show amount of time in minutes and seconds?
  • TitanG
Replies
6
Views
137K
Fred Smith
F
S
4 digits required for a number
  • Sandeep
Replies
1
Views
186K
Sheeloo
S
D
Auto formatting
  • deegee
Replies
3
Views
118K
Joel
J
W
How delete to end of file; comp keeps adding rows; over 3000!
  • whalesong
Replies
1
Views
345K
Sheeloo
S
D
i lost my worksheet in excel
  • Denise
Replies
1
Views
131K
Chip Pearson
C
J
Matching error
  • John
Replies
4
Views
415K
John
J
M
text substitution
  • Mark
Replies
2
Views
102K
Mark
M
A
Is there an easy way to delete empty columns?
  • Acanesfan
Replies
2
Views
81K
Gary''s Student
G
T
subtract 2 cells and get blank instead of 0.0
  • tpeter
Replies
3
Views
402K
klswvu
K
C
VLOOKUP and OFFSET
  • CEG
Replies
3
Views
302K
T. Valko
T
S
sumproduct basic help
  • Susan
Replies
8
Views
753K
Bob Phillips
B
D
drop down list function help
  • doodiehow
Replies
2
Views
382K
Gord Dibben
G
D
how to know the original creator of one excel?
  • Desin Dai
Replies
3
Views
256K
Gord Dibben
G
G
Need an input box when user selects a value in a drop down box
  • Guest
Replies
4
Views
266K
Sara
S
A
Removing blank cells in rows of data
  • Andy in Edinburgh
Replies
8
Views
179K
Gord Dibben
G
S
how do I add a row when the second last one is used
  • Scott
Replies
2
Views
61K
Gord Dibben
G
S
Similiar data on two different sheets - how to ID what is differen
  • Steve
Replies
8
Views
668K
Bob Bridges
B
D
Calculating quarters of a year.
  • dalymjl
Replies
4
Views
431K
dalymjl
D
F
Autofill Format
  • Fozzie Bear
Replies
3
Views
290K
Fozzie Bear
F
D
Deleting Rows Between Empty Cells
  • Daren
Replies
6
Views
206K
Daren
D
G
Is there a formula for conditional concatenating?
  • Guest
Replies
11
Views
562K
gsedwardsee
G
F
countif criteria sg
  • Fred Loh
Replies
7
Views
800K
Don Guillett
D
W
Excel 07 / Data Validation / List /
  • WSR
Replies
1
Views
110K
Otto Moehrbach
O
M
Conditional formatting on 2nd cell
  • mdavison
Replies
5
Views
339K
mdavison
M
K
financial spreadshee
  • Kristie Cobb
Replies
1
Views
190K
Don Guillett
D
K
Excel macro which prompts for input and moves to a cell - repeated
  • KenZimbo
Replies
2
Views
134K
Don Guillett
D
P
Transposing multiple columns to rows
  • Pittman
Replies
5
Views
483K
Max
M
R
IN EXCEL: R1,243.00 CONVERTING TO ONE THOUSAND, TWO HUNDRED AND FO
  • Rand Values
Replies
1
Views
59K
Ashish Mathur
A
A
How do I copy numeric section of cell from alpha-numeric cell
  • ACCAguy
Replies
7
Views
549K
Ashish Mathur
A
You must log in or register to post here.
Back
Top