Microsoft Excel Worksheet Functions

Post thread
P
Need to average data if in cells, but ignore blank cells.
  • Paula
Replies
4
Views
3K
Paula
P
D
Remove the formulae, but keep the data
  • Dave Womack
Replies
3
Views
398
Dave Womack
D
N
need help for a beginer!
  • newbie
Replies
3
Views
306
Bassman62
B
S
COUNTIF( {local cells}, {number from other sheet})
  • ShadoShryke
Replies
6
Views
542
T. Valko
T
C
Display multiple results based on one cell
  • Cul
Replies
5
Views
352
Teethless mama
T
T
cell matching issue
  • totalnatal
Replies
1
Views
393
Lars-Åke Aspelin
L
H
View sheets (pages) horizontally
  • Herb
Replies
3
Views
417
Herb
H
S
SUMPRODUCT
  • Srikanth
Replies
1
Views
397
Abdul
A
S
Linking spreadsheet
  • Saintsman
Replies
1
Views
339
Ashish Mathur
A
M
Highlight the cell based on selected value
  • Max
Replies
2
Views
406
Max
M
K
I need a formula.........
  • Keith D.B.
Replies
4
Views
344
Keith D.B.
K
J
conditional formatte date in a1 calculate the date in A2
  • jcurran1ma
Replies
3
Views
430
Shane Devenshire
S
Z
what is the Function for reducing balance depriciation?
  • zamant
Replies
1
Views
483
Shane Devenshire
S
S
sumif?
  • Scott A
Replies
3
Views
320
Shane Devenshire
S
W
New 2007 Sumifs formula - is there a new multiple criteria vlookup
  • westy
Replies
2
Views
1K
Shane Devenshire
S
D
Please Help - Trouble with counting occurrences in external file
  • dz
Replies
2
Views
438
dz
D
N
Problem with array ref (I think!)
  • Nick H
Replies
10
Views
664
T. Valko
T
K
Moved workbook-File name, minimize, maximize and close are not vis
  • KELC-F/A
Replies
2
Views
369
Shane Devenshire
S
N
how do you have 2 criterias be picked up in a lookup?
  • N. Vu
Replies
5
Views
450
Shane Devenshire
S
J
calculate average from non contiguous column, ignoring (0) values
  • Jesse
Replies
3
Views
811
Shane Devenshire
S
O
Excel - text in one cell
  • oMaLLey
Replies
2
Views
230
Gord Dibben
G
T
MAX IF?
  • Tami
Replies
5
Views
342
T. Valko
T
Y
Need help sorting data
  • Yookaroo
Replies
4
Views
512
Yookaroo
Y
A
How can I validate my Excel password against a INI file
  • Andrea
Replies
1
Views
308
jaf
J
P
Combining two functions
  • preyesone
Replies
13
Views
679
Shane Devenshire
S
P
Function to add 3 column (of YES) to give a total % complete
  • preyesone
Replies
7
Views
482
Shane Devenshire
S
R
Combining 2 percentages into one cell and displaying as % format
  • RLind
Replies
5
Views
901
Shane Devenshire
S
P
FREQUENCY with multiple criteria
  • PCLIVE
Replies
6
Views
5K
T. Valko
T
K
Array formulas not working in Excel 2003.
  • kamelone
Replies
2
Views
684
Shane Devenshire
S
R
Worksheet Limit in Workbook
  • Ron
Replies
2
Views
347
Ron
R
D
Logical Function excel 2003
  • Denver
Replies
3
Views
395
Shane Devenshire
S
R
Help
  • Rum
Replies
4
Views
389
Teethless mama
T
C
Index Formula
  • Cow Girl
Replies
8
Views
471
Teethless mama
T
D
sum function
  • dannyboy8
Replies
3
Views
367
Rick Rothstein
R
R
How to not get '0' or '#DIV/0!' in a cell with a percentage formul
  • Rum
Replies
5
Views
966
Jacob Skaria
J
L
Rearreng Manualy in Pivottable
  • LHM
Replies
2
Views
343
Roger Govier
R
J
countifs
  • JRD
Replies
5
Views
402
Shane Devenshire
S
J
Conditional format entire column
  • JC
Replies
3
Views
680
Shane Devenshire
S
J
Weekends
  • JRD
Replies
6
Views
502
Shane Devenshire
S
N
Average of values that need to be looked up from another sheet
  • NLJR
Replies
1
Views
359
Shane Devenshire
S
S
Make them work on the Each cell Value
  • Steved
Replies
7
Views
494
T. Valko
T
J
How can i set a formula which shows 2nd last Monday of the month?
  • J
Replies
5
Views
610
Teethless mama
T
R
Conditional formatting dates?
  • ReapeR
Replies
8
Views
564
Fred Smith
F
E
Creating items list with corresponding prices
  • Excel Help
Replies
6
Views
599
Jacob Skaria
J
B
excel hyperlink text to display and vlookup
  • bluker
Replies
2
Views
6K
bluker
B
J
Sum Value of rows based on two common fields
  • jdg
Replies
5
Views
636
jdg
J
J
How to set formula for poping up the date of next Wednesday....
  • J
Replies
2
Views
507
Mike H
M
S
Assist with formula
  • Soth
Replies
3
Views
491
Soth
S
H
Conditional Sum in Array with wild card and between dates
  • Hank01061567
Replies
3
Views
793
Hank01061567
H
G
Need help displaying odd numbered month
  • Greg L
Replies
3
Views
815
Sheeloo
S
Back
Top