Microsoft Excel Worksheet Functions

B
Add "/" to a date string
  • bpc
Replies
6
Views
33K
Ron Rosenfeld
R
J
Dates and SumProducts
  • Jeff Gross
Replies
2
Views
85K
Jeff Gross
J
A
SUMIF within a range
  • Alonso
Replies
11
Views
256K
T. Valko
T
F
SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value
  • Finny
Replies
3
Views
298K
Finny
F
L
Index backwards
  • LiAD
Replies
7
Views
434K
T. Valko
T
P
Count number of 2008 invoices for customers
  • Pierre
Replies
2
Views
166K
Pierre
P
E
Pricing - Sliding Scale Price Markup
  • Ed
Replies
9
Views
977K
Ed
E
E
Excel statistics
  • ekonomija
Replies
1
Views
26K
Wigi
W
P
How to verify selected data from drop-down list?
  • PG
Replies
1
Views
139K
Spiky
S
E
cell formula for using progressive information in other cells
  • EG
Replies
5
Views
310K
EG
E
E
Formula Result is "V6", need Excel to use cell "V6", not the resul
  • Erik
Replies
3
Views
286K
Erik
E
N
Can I use copy function in an if statement?
  • Neese
Replies
3
Views
103K
Spiky
S
S
Cell format to use for calculation
  • scott
Replies
4
Views
341K
Teethless mama
T
L
Match and return functions
  • LiAD
Replies
14
Views
869K
LiAD
L
L
date boolean function
  • Lisa
Replies
6
Views
617K
Dave Peterson
D
L
boolean question
  • Lisa
Replies
1
Views
130K
Duke Carey
D
S
Filter Data
  • Sivassou...
Replies
2
Views
209K
Sivassou...
S
B
allow insert rows = false for only some of the worksheet
  • bill311
Replies
1
Views
168K
Roger Govier
R
G
can excel automatically enter the date data in a cell was entered
  • Guest
Replies
4
Views
69K
Roger Govier
R
R
averageif (XL2007)
  • RobFJ
Replies
2
Views
298K
RobFJ
R
K
Combine 2 formulas
  • Ken
Replies
5
Views
88K
Ken
K
E
Statistical - text function (counting)
  • ekonomija
Replies
1
Views
150K
Rick Rothstein
R
P
lookup specific value in a column and show it in a new cell
  • Piotr (Peter)
Replies
3
Views
46K
Pete_UK
P
E
SUMPRODUCT - Count Various criteria in same column (exclude other)
  • EricB
Replies
8
Views
596K
EricB
E
P
change dob
  • pavlos
Replies
1
Views
131K
Bob Bridges
B
N
copy formula as is to new cell in an if statement
  • Neese
Replies
1
Views
30K
Bob Bridges
B
A
cannot convert text string into value
  • Andy
Replies
16
Views
2M
Andy
A
R
Combine daily data from different worksheets
  • Rhino721
Replies
2
Views
117K
Rhino721
R
T
COUNTIF Function with variables
  • TJ
Replies
6
Views
219K
TJ
T
R
Workbook Name in Cell
  • RoadKill
Replies
2
Views
54K
StpNs
S
B
multiple value lookup
  • Benny
Replies
1
Views
140K
Max
M
G
How to populate a cell with numeric value based on textselected from pull down in adjacent cell?
  • Garth Rodericks
Replies
1
Views
367K
Max
M
H
adding a percentage to a column of numbers
  • hld
Replies
3
Views
220K
Gord Dibben
G
J
Counting text cells then multiplying by a value in another column
  • Jo
Replies
6
Views
738K
Max
M
Y
How to set "alignment wrap" as default?
  • yakky
Replies
2
Views
281K
Gord Dibben
G
J
Please help with vlookup function
  • JMiller
Replies
4
Views
170K
Max
M
M
dynamic vlookup
  • MrMmnico
Replies
6
Views
344K
Max
M
C
When you hit Save on a template, how can you save as worksheet?
  • cwgirl1982
Replies
1
Views
258K
Dave Peterson
D
T
I need something similar to an IF formula
  • trinalyn3
Replies
2
Views
24K
Alonso
A
T
Return Last Value in a Row formula
  • Txlonghorn76
Replies
5
Views
55K
T. Valko
T
N
range of numbers
  • neuromoe
Replies
1
Views
72K
Pete_UK
P
P
Find a theme in a article in a single cell
  • Prashanth KR
Replies
1
Views
58K
John C
J
J
SUMIF with two condition from two ranges
  • JBoyer
Replies
3
Views
194K
JBoyer
J
C
Emailing an Excel Worksheet
  • carl
Replies
1
Views
237K
FSt1
F
J
Referencing Last Cell
  • jlo
Replies
8
Views
514K
T. Valko
T
M
SUMIF sum range
  • martinson
Replies
6
Views
48K
Alonso
A
J
If and Then
  • J
Replies
6
Views
142K
J
J
S
Count instances based on two criteria
  • Stuart Mantel
Replies
2
Views
154K
Duke Carey
D
F
how do i add commas in a single cell?
  • Footlight
Replies
2
Views
272K
Spiky
S
H
Changing formula totals
  • harwookf
Replies
2
Views
177K
harwookf
H
You must log in or register to post here.
Back
Top