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
406
Dave Womack
D
N
need help for a beginer!
  • newbie
Replies
3
Views
311
Bassman62
B
S
COUNTIF( {local cells}, {number from other sheet})
  • ShadoShryke
Replies
6
Views
579
T. Valko
T
C
Display multiple results based on one cell
  • Cul
Replies
5
Views
373
Teethless mama
T
T
cell matching issue
  • totalnatal
Replies
1
Views
402
Lars-Åke Aspelin
L
H
View sheets (pages) horizontally
  • Herb
Replies
3
Views
430
Herb
H
S
SUMPRODUCT
  • Srikanth
Replies
1
Views
430
Abdul
A
S
Linking spreadsheet
  • Saintsman
Replies
1
Views
351
Ashish Mathur
A
M
Highlight the cell based on selected value
  • Max
Replies
2
Views
431
Max
M
K
I need a formula.........
  • Keith D.B.
Replies
4
Views
365
Keith D.B.
K
J
conditional formatte date in a1 calculate the date in A2
  • jcurran1ma
Replies
3
Views
450
Shane Devenshire
S
Z
what is the Function for reducing balance depriciation?
  • zamant
Replies
1
Views
485
Shane Devenshire
S
S
sumif?
  • Scott A
Replies
3
Views
334
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
466
dz
D
N
Problem with array ref (I think!)
  • Nick H
Replies
10
Views
713
T. Valko
T
K
Moved workbook-File name, minimize, maximize and close are not vis
  • KELC-F/A
Replies
2
Views
380
Shane Devenshire
S
N
how do you have 2 criterias be picked up in a lookup?
  • N. Vu
Replies
5
Views
483
Shane Devenshire
S
J
calculate average from non contiguous column, ignoring (0) values
  • Jesse
Replies
3
Views
848
Shane Devenshire
S
O
Excel - text in one cell
  • oMaLLey
Replies
2
Views
232
Gord Dibben
G
T
MAX IF?
  • Tami
Replies
5
Views
342
T. Valko
T
Y
Need help sorting data
  • Yookaroo
Replies
4
Views
533
Yookaroo
Y
A
How can I validate my Excel password against a INI file
  • Andrea
Replies
1
Views
309
jaf
J
P
Combining two functions
  • preyesone
Replies
13
Views
782
Shane Devenshire
S
P
Function to add 3 column (of YES) to give a total % complete
  • preyesone
Replies
7
Views
506
Shane Devenshire
S
R
Combining 2 percentages into one cell and displaying as % format
  • RLind
Replies
5
Views
912
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
711
Shane Devenshire
S
R
Worksheet Limit in Workbook
  • Ron
Replies
2
Views
350
Ron
R
D
Logical Function excel 2003
  • Denver
Replies
3
Views
407
Shane Devenshire
S
R
Help
  • Rum
Replies
4
Views
418
Teethless mama
T
C
Index Formula
  • Cow Girl
Replies
8
Views
516
Teethless mama
T
D
sum function
  • dannyboy8
Replies
3
Views
379
Rick Rothstein
R
R
How to not get '0' or '#DIV/0!' in a cell with a percentage formul
  • Rum
Replies
5
Views
998
Jacob Skaria
J
L
Rearreng Manualy in Pivottable
  • LHM
Replies
2
Views
353
Roger Govier
R
J
countifs
  • JRD
Replies
5
Views
402
Shane Devenshire
S
J
Conditional format entire column
  • JC
Replies
3
Views
696
Shane Devenshire
S
J
Weekends
  • JRD
Replies
6
Views
539
Shane Devenshire
S
N
Average of values that need to be looked up from another sheet
  • NLJR
Replies
1
Views
380
Shane Devenshire
S
S
Make them work on the Each cell Value
  • Steved
Replies
7
Views
518
T. Valko
T
J
How can i set a formula which shows 2nd last Monday of the month?
  • J
Replies
5
Views
631
Teethless mama
T
R
Conditional formatting dates?
  • ReapeR
Replies
8
Views
590
Fred Smith
F
E
Creating items list with corresponding prices
  • Excel Help
Replies
6
Views
633
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
679
jdg
J
J
How to set formula for poping up the date of next Wednesday....
  • J
Replies
2
Views
526
Mike H
M
S
Assist with formula
  • Soth
Replies
3
Views
508
Soth
S
H
Conditional Sum in Array with wild card and between dates
  • Hank01061567
Replies
3
Views
818
Hank01061567
H
G
Need help displaying odd numbered month
  • Greg L
Replies
3
Views
842
Sheeloo
S
Back
Top