Microsoft Excel Worksheet Functions

E
recolor cell upon entry
  • Electric Julie
Replies
1
Views
79K
Sheeloo
S
S
Hyperlink to a file that changes names daily
  • sonarmark
Replies
1
Views
129K
~L
L
D
average a continuous group of numbers and negative numbers are 0
  • Dumbfounded
Replies
3
Views
40K
Chip Pearson
C
W
AVERAGE IF in array not working
  • WildWill
Replies
4
Views
298K
WildWill
W
D
Conditional Formatting to Check for Blanks
  • Daren
Replies
5
Views
267K
Daren
D
R
Find value between range & return text
  • RangeFinder
Replies
1
Views
303K
Teethless mama
T
D
IF Statement to Check for Blanks
  • Daren
Replies
5
Views
133K
Daren
D
C
Pivot - top 10 stocks & missing info
  • Christine
Replies
2
Views
171K
MX9
M
S
Excel function to convert month-day-year to mm/dd/yyyy
  • sweetthing4luc
Replies
7
Views
300K
Rick Rothstein
R
J
TRIM function
  • JockW
Replies
6
Views
391K
JockW
J
E
In Excel, how do I add "not in list" to an if statement?
  • Elana
Replies
3
Views
336K
Mike H
M
S
EXCEL 2000 - IF function returns wrong result from logical test
  • Sean Duffy
Replies
8
Views
955K
ShaneDevenshire
S
K
Is this type of formula possible in Excel?
  • KP
Replies
3
Views
273K
ShaneDevenshire
S
J
Excel formula using non-literal values
  • jbdmom
Replies
3
Views
111K
ShaneDevenshire
S
J
stopwatch average per mile
  • JBT
Replies
2
Views
26K
Sean Timmons
S
M
VLOOKUP returning #N/A
  • Michelle7890
Replies
5
Views
206K
Sheeloo
S
M
nesting sumif functions
  • Macil
Replies
5
Views
129K
Harlan Grove
H
A
I need a formula to add up the sum of an employee
  • Amin
Replies
3
Views
245K
John C
J
L
Subtracting 2 hours from a time....
  • Literalgar
Replies
2
Views
419K
John C
J
G
Validation based on three conditions
  • gojakie
Replies
6
Views
426K
John C
J
S
Must save to view formula results
  • S R
Replies
6
Views
190K
John C
J
B
fill handle in Excel
  • Broadbrook
Replies
4
Views
71K
ShaneDevenshire
S
A
#missing!
  • Arne Hegefors
Replies
2
Views
80K
Peo Sjoblom
P
S
displaying a zero in phone numbers
  • stosh
Replies
3
Views
23K
Brad
B
D
Block copy/insert of 5 rows, then update formula below?
  • David
Replies
2
Views
355K
David
D
J
If statements resulting in formatting of cells
  • Jen
Replies
3
Views
333K
ShaneDevenshire
S
S
Inserting a formula into a sentance.
  • Stacey
Replies
3
Views
155K
Gord Dibben
G
H
cell for date last updated
  • houseman
Replies
1
Views
23K
Gary''s Student
G
J
Shading Rows With IF Statements?
  • JPS
Replies
5
Views
437K
Gord Dibben
G
J
Dividing Data between sheets in a workbook
  • Jenny
Replies
1
Views
81K
Don Guillett
D
T
Unprotect sheet command - How do I do this?
  • TKM
Replies
5
Views
446K
Mike H
M
G
Help please - Lookup required - not sure!
  • GillianX
Replies
1
Views
193K
Bernie Deitrick
B
J
How to SUMIF + IF without !VALUE#
  • JC-PS
Replies
3
Views
70K
JC-PS
J
A
Calculation error in Workhours
  • Andrew
Replies
3
Views
326K
Chip Pearson
C
C
first letter of weekday
  • Carla
Replies
4
Views
276K
John C
J
J
Rev number
  • JPS
Replies
3
Views
59K
Gary''s Student
G
B
perform a regression analysis
  • Becky1103
Replies
2
Views
257K
Roberta
R
M
Conditional Countif function?
  • Miketsw
Replies
3
Views
324K
Mike H
M
K
Remove blank from pivot table
  • Kishor Bhalerao
Replies
5
Views
268K
yasho bhushan
Y
G
How do I display lines depnding on a cell critrera
  • Greg S
Replies
3
Views
66K
Max
M
S
Count based on Conditions
  • shyamgnair
Replies
1
Views
204K
Stefi
S
G
How do I display certain lines depnding on a cell critrera
  • Greg S
Replies
1
Views
27K
Mike H
M
S
Separate Text from a cell by space into other cells
  • Sajjad
Replies
5
Views
549K
David Biddulph
D
F
Warning Messages
  • fabio
Replies
3
Views
120K
Stefi
S
S
Significant figures as a conditional format
  • stephenp
Replies
3
Views
352K
Bob Phillips
B
S
Still struggling with Vlookup
  • Sprowler
Replies
2
Views
74K
Arvi Laanemets
A
C
copy command within a formula
  • copy commad in excel formula
Replies
2
Views
118K
ShaneDevenshire
S
M
Lotus 123 @nsum function equivalent in excel(?)
  • marke54805
Replies
10
Views
563K
Rick Rothstein
R
D
Subtotalling
  • Delamgbc
Replies
1
Views
257K
ShaneDevenshire
S
J
Moving between sheets in Excel w/o keyboard
  • Joe
Replies
1
Views
134K
ShaneDevenshire
S
You must log in or register to post here.
Back
Top