Microsoft Excel Worksheet Functions

S
SumProduct with dates
  • Spike
Replies
4
Views
382K
Shane Devenshire
S
C
Cell formatting
  • camp732
Replies
2
Views
32K
Shane Devenshire
S
O
Entries per year
  • onebodaciousbabe03
Replies
1
Views
47K
Shane Devenshire
S
C
set default value for a cell
  • CEM Matt
Replies
3
Views
75K
Fred Smith
F
I
Help getting 2 formulas into one
  • Iriemon
Replies
2
Views
275K
Rajesh Mehmi
R
L
Countif Formula
  • Lime
Replies
9
Views
127K
Shane Devenshire
S
J
CF help please
  • j5b9721
Replies
4
Views
26K
j5b9721
J
A
Calculate Revenue based on dates within a month
  • Annie
Replies
4
Views
332K
Annie
A
D
Using a variable in the Range function
  • Dee Sperling
Replies
3
Views
202K
Dave Peterson
D
T
Macro & VB101 and Excel
  • Ty
Replies
3
Views
211K
Ty
T
C
worksheet formulas
  • camp732
Replies
12
Views
303K
T. Valko
T
S
Border Cells
  • Steved
Replies
4
Views
254K
Steved
S
B
Determine Most/Least Frequent Date from List
  • bpc
Replies
2
Views
143K
bpc
B
R
percentage calculation
  • rpi929
Replies
3
Views
279K
JoeU2004
J
G
conditional formatting of dates
  • Gretchster
Replies
3
Views
194K
Shane Devenshire
S
S
multi-array sumproduct
  • Steve
Replies
6
Views
413K
Herbert Seidenberg
H
D
matching from an unsorted list
  • d fallon
Replies
1
Views
56K
Fred Smith
F
B
CONCATENATE zeros
  • Bullocks
Replies
5
Views
184K
Bullocks
B
T
Dynamic Range Setup...
  • Trevor Williams
Replies
8
Views
323K
Trevor Williams
T
T
Need to Pull Those that Start with Letter P
  • Toria
Replies
2
Views
37K
Toria
T
G
I would like to change numbers in a cell automatically
  • Gerald
Replies
1
Views
119K
Luke M
L
B
How do I split a sheet so I can have different amount of columns?
  • birmel
Replies
1
Views
168K
Luke M
L
N
Project Time in a year formula
  • niallf
Replies
0
Views
212K
niallf
N
C
Find LAST date when corresponing min value became available
  • Carl S.
Replies
7
Views
359K
Max
M
K
%RSD
  • Kwei
Replies
6
Views
271K
Jerry W. Lewis
J
&
Counting results from a lookup
  • &e7
Replies
1
Views
97K
&e7
&
C
Date Format
  • Christopher Naveen
Replies
2
Views
182K
Stefi
S
J
How to do this formula???
  • jimmy
Replies
2
Views
314K
jimmy
J
J
How to round down a value to the inferior multiple of 5
  • jimmy
Replies
3
Views
131K
jimmy
J
S
Any sugguestion to set up this Calculation?
  • Sky
Replies
10
Views
589K
Sky
S
O
Multiple count if
  • OzzyJim
Replies
2
Views
284K
OzzyJim
O
P
Insert Column, Keep Average range
  • pwarrenphoto
Replies
1
Views
231K
Shane Devenshire
S
D
IF column contains certain text return value of corresponding row
  • Daly
Replies
7
Views
479K
Shane Devenshire
S
H
Sum formula help
  • HaSt2307
Replies
7
Views
261K
T. Valko
T
A
Excel spreadsheet Password is lost
  • Amit Dave
Replies
1
Views
122K
FSt1
F
D
=sign(--counta(range)) not working righ t
  • dlotz
Replies
4
Views
25K
JoeU2004
J
C
parsing a full name out into Last, First, Middle
  • Craig
Replies
2
Views
376K
Ron Rosenfeld
R
S
Average of Years employed
  • SGee
Replies
4
Views
410K
T. Valko
T
A
How do I protect cells or a range of cells in excel spreadsheet?
  • Abundance
Replies
1
Views
208K
Rajesh Mehmi
R
I
Help with SUMIF formula
  • Iriemon
Replies
3
Views
224K
RagDyer
R
E
Ok how about this formula using days :-/
  • Excel ??
Replies
1
Views
138K
Niek Otten
N
J
Saving sheet data to another sheet automatically
  • John Aikin
Replies
7
Views
591K
Per Jessen
P
J
State names into abbreviations
  • jennie
Replies
2
Views
128K
Lars-Åke Aspelin
L
T
countif with 2 criteria
  • tpeter
Replies
4
Views
115K
Mike H
M
S
consolidate multiple worksheets
  • se7098
Replies
13
Views
871K
Ron de Bruin
R
E
I need Help with a count cell text formula
  • Excel ??
Replies
4
Views
69K
Shane Devenshire
S
R
Differenec formula: Dnt need '0' as a result;Rather have a blank c
  • Rum
Replies
4
Views
551K
Gord Dibben
G
K
Count Number of occurences of several texts in a range of cells
  • kbeirne
Replies
3
Views
165K
Mike H
M
S
Vlookup for a max value ?
  • Steve
Replies
4
Views
391K
Steve
S
T
Range
  • Tara
Replies
1
Views
18K
Gord Dibben
G
You must log in or register to post here.
Back
Top