Microsoft Excel Worksheet Functions

D
Remove the formulae, but keep the data
  • Dave Womack
Replies
3
Views
155K
Dave Womack
D
N
need help for a beginer!
  • newbie
Replies
3
Views
138K
Bassman62
B
S
COUNTIF( {local cells}, {number from other sheet})
  • ShadoShryke
Replies
6
Views
297K
T. Valko
T
C
Display multiple results based on one cell
  • Cul
Replies
5
Views
167K
Teethless mama
T
T
cell matching issue
  • totalnatal
Replies
1
Views
73K
Lars-Åke Aspelin
L
H
View sheets (pages) horizontally
  • Herb
Replies
3
Views
605K
Herb
H
S
SUMPRODUCT
  • Srikanth
Replies
1
Views
262K
Abdul
A
S
Linking spreadsheet
  • Saintsman
Replies
1
Views
162K
Ashish Mathur
A
M
Highlight the cell based on selected value
  • Max
Replies
2
Views
368K
Max
M
K
I need a formula.........
  • Keith D.B.
Replies
4
Views
420K
Keith D.B.
K
J
conditional formatte date in a1 calculate the date in A2
  • jcurran1ma
Replies
3
Views
217K
Shane Devenshire
S
Z
what is the Function for reducing balance depriciation?
  • zamant
Replies
1
Views
37K
Shane Devenshire
S
S
sumif?
  • Scott A
Replies
3
Views
160K
Shane Devenshire
S
W
New 2007 Sumifs formula - is there a new multiple criteria vlookup
  • westy
Replies
2
Views
324K
Shane Devenshire
S
D
Please Help - Trouble with counting occurrences in external file
  • dz
Replies
2
Views
293K
dz
D
N
Problem with array ref (I think!)
  • Nick H
Replies
10
Views
476K
T. Valko
T
K
Moved workbook-File name, minimize, maximize and close are not vis
  • KELC-F/A
Replies
2
Views
274K
Shane Devenshire
S
N
how do you have 2 criterias be picked up in a lookup?
  • N. Vu
Replies
5
Views
198K
Shane Devenshire
S
J
calculate average from non contiguous column, ignoring (0) values
  • Jesse
Replies
3
Views
499K
Shane Devenshire
S
O
Excel - text in one cell
  • oMaLLey
Replies
2
Views
32K
Gord Dibben
G
T
MAX IF?
  • Tami
Replies
5
Views
47K
T. Valko
T
Y
Need help sorting data
  • Yookaroo
Replies
4
Views
164K
Yookaroo
Y
A
How can I validate my Excel password against a INI file
  • Andrea
Replies
1
Views
57K
jaf
J
P
Combining two functions
  • preyesone
Replies
13
Views
703K
Shane Devenshire
S
P
Function to add 3 column (of YES) to give a total % complete
  • preyesone
Replies
7
Views
420K
Shane Devenshire
S
R
Combining 2 percentages into one cell and displaying as % format
  • RLind
Replies
5
Views
167K
Shane Devenshire
S
P
FREQUENCY with multiple criteria
  • PCLIVE
Replies
6
Views
687K
T. Valko
T
K
Array formulas not working in Excel 2003.
  • kamelone
Replies
2
Views
251K
Shane Devenshire
S
R
Worksheet Limit in Workbook
  • Ron
Replies
2
Views
63K
Ron
R
D
Logical Function excel 2003
  • Denver
Replies
3
Views
128K
Shane Devenshire
S
R
Help
  • Rum
Replies
4
Views
516K
Teethless mama
T
C
Index Formula
  • Cow Girl
Replies
8
Views
513K
Teethless mama
T
D
sum function
  • dannyboy8
Replies
3
Views
206K
Rick Rothstein
R
R
How to not get '0' or '#DIV/0!' in a cell with a percentage formul
  • Rum
Replies
5
Views
350K
Jacob Skaria
J
L
Rearreng Manualy in Pivottable
  • LHM
Replies
2
Views
52K
Roger Govier
R
J
countifs
  • JRD
Replies
5
Views
30K
Shane Devenshire
S
J
Conditional format entire column
  • JC
Replies
3
Views
447K
Shane Devenshire
S
J
Weekends
  • JRD
Replies
6
Views
288K
Shane Devenshire
S
N
Average of values that need to be looked up from another sheet
  • NLJR
Replies
1
Views
62K
Shane Devenshire
S
S
Make them work on the Each cell Value
  • Steved
Replies
7
Views
290K
T. Valko
T
J
How can i set a formula which shows 2nd last Monday of the month?
  • J
Replies
5
Views
296K
Teethless mama
T
R
Conditional formatting dates?
  • ReapeR
Replies
8
Views
233K
Fred Smith
F
E
Creating items list with corresponding prices
  • Excel Help
Replies
6
Views
169K
Jacob Skaria
J
B
excel hyperlink text to display and vlookup
  • bluker
Replies
2
Views
275K
bluker
B
J
Sum Value of rows based on two common fields
  • jdg
Replies
5
Views
358K
jdg
J
J
How to set formula for poping up the date of next Wednesday....
  • J
Replies
2
Views
202K
Mike H
M
S
Assist with formula
  • Soth
Replies
3
Views
176K
Soth
S
H
Conditional Sum in Array with wild card and between dates
  • Hank01061567
Replies
3
Views
330K
Hank01061567
H
G
Need help displaying odd numbered month
  • Greg L
Replies
3
Views
181K
Sheeloo
S
O
count formula
  • OKY
Replies
2
Views
288K
OKY
O
You must log in or register to post here.
Back
Top