Microsoft Excel Worksheet Functions

Post thread
A
Substitutions
  • Amco
Replies
1
Views
324
Sheeloo
S
B
Add "/" to a date string
  • bpc
Replies
6
Views
259
Ron Rosenfeld
R
J
Dates and SumProducts
  • Jeff Gross
Replies
2
Views
544
Jeff Gross
J
A
SUMIF within a range
  • Alonso
Replies
11
Views
534
T. Valko
T
F
SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value
  • Finny
Replies
3
Views
1K
Finny
F
L
Index backwards
  • LiAD
Replies
7
Views
448
T. Valko
T
P
Count number of 2008 invoices for customers
  • Pierre
Replies
2
Views
391
Pierre
P
E
Pricing - Sliding Scale Price Markup
  • Ed
Replies
9
Views
6K
Ed
E
E
Excel statistics
  • ekonomija
Replies
1
Views
366
Wigi
W
P
How to verify selected data from drop-down list?
  • PG
Replies
1
Views
333
Spiky
S
E
cell formula for using progressive information in other cells
  • EG
Replies
5
Views
663
EG
E
E
Formula Result is "V6", need Excel to use cell "V6", not the resul
  • Erik
Replies
3
Views
675
Erik
E
N
Can I use copy function in an if statement?
  • Neese
Replies
3
Views
272
Spiky
S
S
Cell format to use for calculation
  • scott
Replies
4
Views
515
Teethless mama
T
L
Match and return functions
  • LiAD
Replies
14
Views
598
LiAD
L
L
date boolean function
  • Lisa
Replies
6
Views
514
Dave Peterson
D
L
boolean question
  • Lisa
Replies
1
Views
335
Duke Carey
D
S
Filter Data
  • Sivassou...
Replies
2
Views
266
Sivassou...
S
B
allow insert rows = false for only some of the worksheet
  • bill311
Replies
1
Views
460
Roger Govier
R
G
can excel automatically enter the date data in a cell was entered
  • Guest
Replies
4
Views
784
Roger Govier
R
R
averageif (XL2007)
  • RobFJ
Replies
2
Views
525
RobFJ
R
K
Combine 2 formulas
  • Ken
Replies
5
Views
570
Ken
K
E
Statistical - text function (counting)
  • ekonomija
Replies
1
Views
399
Rick Rothstein
R
P
lookup specific value in a column and show it in a new cell
  • Piotr (Peter)
Replies
3
Views
315
Pete_UK
P
E
SUMPRODUCT - Count Various criteria in same column (exclude other)
  • EricB
Replies
8
Views
691
EricB
E
P
change dob
  • pavlos
Replies
1
Views
396
Bob Bridges
B
N
copy formula as is to new cell in an if statement
  • Neese
Replies
1
Views
354
Bob Bridges
B
A
cannot convert text string into value
  • Andy
Replies
16
Views
759
Andy
A
R
Combine daily data from different worksheets
  • Rhino721
Replies
2
Views
419
Rhino721
R
T
COUNTIF Function with variables
  • TJ
Replies
6
Views
674
TJ
T
R
Workbook Name in Cell
  • RoadKill
Replies
2
Views
329
StpNs
S
B
multiple value lookup
  • Benny
Replies
1
Views
267
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
829
Max
M
H
adding a percentage to a column of numbers
  • hld
Replies
3
Views
410
Gord Dibben
G
J
Counting text cells then multiplying by a value in another column
  • Jo
Replies
6
Views
971
Max
M
Y
How to set "alignment wrap" as default?
  • yakky
Replies
2
Views
283
Gord Dibben
G
J
Please help with vlookup function
  • JMiller
Replies
4
Views
484
Max
M
M
dynamic vlookup
  • MrMmnico
Replies
6
Views
447
Max
M
C
When you hit Save on a template, how can you save as worksheet?
  • cwgirl1982
Replies
1
Views
498
Dave Peterson
D
T
I need something similar to an IF formula
  • trinalyn3
Replies
2
Views
352
Alonso
A
T
Return Last Value in a Row formula
  • Txlonghorn76
Replies
5
Views
528
T. Valko
T
N
range of numbers
  • neuromoe
Replies
1
Views
289
Pete_UK
P
P
Find a theme in a article in a single cell
  • Prashanth KR
Replies
1
Views
310
John C
J
J
SUMIF with two condition from two ranges
  • JBoyer
Replies
3
Views
444
JBoyer
J
C
Emailing an Excel Worksheet
  • carl
Replies
1
Views
446
FSt1
F
J
Referencing Last Cell
  • jlo
Replies
8
Views
504
T. Valko
T
M
SUMIF sum range
  • martinson
Replies
6
Views
507
Alonso
A
J
If and Then
  • J
Replies
6
Views
349
J
J
S
Count instances based on two criteria
  • Stuart Mantel
Replies
2
Views
555
Duke Carey
D
F
how do i add commas in a single cell?
  • Footlight
Replies
2
Views
638
Spiky
S
Back
Top