Microsoft Excel Worksheet Functions

J
Using the numeric contents of a cell to define row number
  • JRD
Replies
4
Views
187K
JRD
J
B
Column1 and Column2
  • beata
Replies
2
Views
86K
beata
B
J
SumIf with date range
  • juliejg1
Replies
5
Views
499K
T. Valko
T
R
Wild Card for SUMIF criteria
  • Ronbo
Replies
2
Views
292K
Ronbo
R
U
date calculation
  • user@msn
Replies
2
Views
76K
Ron Rosenfeld
R
K
What is the Zero Cap function in excel?
  • KICI
Replies
4
Views
71K
ilia
I
J
SUMPRODUCT with #VALUE error
  • Joe Gieder
Replies
3
Views
46K
Joe Gieder
J
A
Exel 2003 Copy Formula Problem
  • addison
Replies
4
Views
402K
addison
A
S
Advanced Countif
  • SFCWoods
Replies
6
Views
495K
Don Guillett
D
J
Counting once more
  • JRD
Replies
2
Views
240K
T. Valko
T
T
Finding Cell that changes from a Positive to a Negitive number
  • tpeter
Replies
2
Views
208K
Ron Rosenfeld
R
F
formula adding range of cells that contains alpha numeric
  • Formulas
Replies
1
Views
171K
David Biddulph
D
P
Copy File Formulas between Files w/o the link
  • PJ in CO
Replies
3
Views
156K
PJ in CO
P
N
Nesting COUNTIF for multiple criteria in multiple columns
  • NeedExcelHelp07
Replies
1
Views
198K
Bob Phillips
B
J
Sum ignoring cells with error
  • JRD
Replies
1
Views
212K
Peo Sjoblom
P
R
duplicate info in cells
  • ranvin56
Replies
2
Views
72K
Gord Dibben
G
J
Create a custom fill series or sorting order
  • jerminski73
Replies
1
Views
165K
Gord Dibben
G
A
Copy/Paste Special in Excel
  • April H
Replies
1
Views
192K
Gord Dibben
G
T
Time in excel
  • tangle
Replies
3
Views
70K
tangle
T
L
Converting Text Dates to Serial Numbers
  • LPS
Replies
4
Views
155K
RagDyeR
R
K
select multiple criteria multiple worksheets
  • koneil
Replies
1
Views
298K
Max
M
I
How can i create new function library ???
  • Irfan Khan
Replies
2
Views
146K
Gord Dibben
G
J
multiplication of a blank cell
  • jerminski73
Replies
5
Views
447K
jerminski73
J
B
Array formula to display 1 if concatentaed values differ..
  • bony_tony
Replies
3
Views
42K
bony_tony
B
M
How do I set all caps as the default?
  • Mark Barnard
Replies
10
Views
858K
Gord Dibben
G
T
Pivot table
  • Terry
Replies
4
Views
220K
Terry
T
D
Formulas with-an an array
  • Dave
Replies
2
Views
301K
ilia
I
J
copy data and formulas from a column and paste into a row
  • john.laffe
Replies
1
Views
115K
ryguy7272
R
F
Variable in if statement
  • Francis Hookham
Replies
9
Views
180K
Francis Hookham
F
D
Reverse Text then combine rows
  • darnoldman
Replies
4
Views
462K
darnoldman
D
F
Return a smallest date
  • Freshman
Replies
8
Views
392K
Max
M
S
Excel 2003 Formulas
  • Skeeter man
Replies
7
Views
406K
David Biddulph
D
C
Reducing file capacity
  • Christopher Naveen
Replies
3
Views
259K
Christopher Naveen
C
G
Blamk cells and 0 values
  • gtm16
Replies
6
Views
45K
Robert McCurdy
R
T
Sorting 2 colums to get numbers to match ?
  • thriller
Replies
2
Views
418K
Max
M
S
change 20071201 to date
  • Stampertje
Replies
2
Views
98K
Stefi
S
N
How to Copy single Cell into Multiple cells
  • Nitesh Mathur
Replies
3
Views
206K
Max
M
J
counting cells containing certain ranges of dates
  • JRD
Replies
1
Views
148K
Mike H
M
J
Converting text to numbers
  • JRD
Replies
1
Views
160K
Mike H
M
K
use "countif" function to count cells by colour
  • ken
Replies
1
Views
234K
Carim
C
E
Conditional formatting
  • ellinor2304
Replies
5
Views
509K
Max
M
S
Number repeated in an array
  • Sai Krishna
Replies
1
Views
112K
carlo
C
J
Compare two columns by aligning same-values and spacing out differences
  • Jon Davis
Replies
1
Views
214K
Max
M
S
After midnight
  • Steved
Replies
3
Views
182K
T. Valko
T
P
Excel 2007: Pivottable and Rank
  • peter
Replies
3
Views
222K
Herbert Seidenberg
H
J
How to Highlight Two Rows With Two Columns of Duplicate Values
  • JSteph
Replies
1
Views
79K
Max
M
D
i WANT TO ADD SEVERAL WORKSHEETS(AND DIVIDE THE TOTAL) NEED ASSIS
  • Diana G
Replies
1
Views
33K
Gord Dibben
G
J
Function to show the greatest number of characters
  • juliejg1
Replies
4
Views
255K
Ron Rosenfeld
R
S
Dates
  • smooney
Replies
17
Views
720K
Harlan Grove
H
F
How can I use sumproduct with different size ranges?
  • Fen
Replies
3
Views
165K
RagDyer
R
You must log in or register to post here.
Back
Top