Microsoft Excel Worksheet Functions

R
Extracting information to automatically find previous value.
  • Rocko
Replies
3
Views
237K
T. Valko
T
F
"AverageIf"
  • fozzie888
Replies
2
Views
27K
Shane Devenshire
S
L
Sum Of Last Two Entries in Rotating Columns
  • Loadmaster
Replies
6
Views
519K
T. Valko
T
A
How do i stop Excel from turning a value into a formula?
  • Annetoinette
Replies
3
Views
341K
Dave Peterson
D
O
Divide by the minimum non-zero number in a range of cells
  • Opus
2
Replies
21
Views
2M
JoeU2004
J
L
Conditional Currency
  • Loadmaster
Replies
5
Views
368K
Allllen
A
K
max value from multiple rows of similar information
  • Karesel
Replies
5
Views
437K
T. Valko
T
D
runtime error 2147221005(800401f3)
  • deen
Replies
1
Views
170K
JLatham
J
S
repeated values
  • sood
Replies
1
Views
103K
Allllen
A
A
YEAR MONTH DAYS COUNTER
  • ad2ad79
Replies
6
Views
505K
Don Guillett
D
A
Max Min Differnce in a Range
  • Albert H. Bell
Replies
6
Views
527K
Albert H. Bell
A
C
2003 Excel
  • CC Bulinski
Replies
2
Views
62K
Bernard Liengme
B
R
If part of a cell = "NVA" then insert "Norfolk" in return cell
  • RNCKWMN
Replies
4
Views
242K
Francis
F
A
Number of total calculation functions
  • appsinoffice2003
Replies
3
Views
174K
Shane Devenshire
S
D
Excell rank= I need to reverse the order
  • Dennis Noble
Replies
2
Views
494K
Shane Devenshire
S
B
Dependent List "Index" Problem
  • Benjamin
Replies
2
Views
66K
Benjamin
B
L
cell formulas
  • Lynn
Replies
3
Views
152K
Gord Dibben
G
J
convert hours and minutes into days
  • Joshua
Replies
2
Views
206K
JE McGimpsey
J
P
Excel cannot complete this task with available resources
  • PSM
Replies
1
Views
149K
Bob Bridges
B
A
Sumif or Sumproduct?
  • alarson01
Replies
2
Views
341K
Bassman62
B
J
How do I change the default header date format in Excel 2007?
  • Jazzman721
Replies
3
Views
311K
Gord Dibben
G
R
Count Unique Values
  • Richard
Replies
7
Views
431K
T. Valko
T
D
DSUM - Need dynamic functionality
  • Don
Replies
8
Views
529K
Harlan Grove
H
D
Data comparison for duplication
  • Donna
Replies
1
Views
137K
Shane Devenshire
S
I
Conditional Formatting
  • it''''''''sh hardy
Replies
4
Views
324K
it''''''''sh hardy
I
J
IF formula for time
  • Joshua
Replies
6
Views
516K
T. Valko
T
J
Difference between date and time
  • Joshua
Replies
7
Views
511K
Rich/rerat
R
S
How to replace a formula string with * in the leading position?
  • Seaq
Replies
3
Views
441K
T. Valko
T
S
Index with mulitple value returns and muliple column returns
  • solar+CSE
Replies
4
Views
299K
T. Valko
T
I
Delete BOTH sets duplicate data in columns (debits/credits)
  • Iamconstance
Replies
1
Views
120K
Bernie Deitrick
B
C
how do I view up to 120,000 rows in office excel 2003
  • Chikanox
Replies
2
Views
159K
Bernard Liengme
B
R
change cell colour according to date.....
  • RichLive
Replies
2
Views
225K
Bernard Liengme
B
F
Naming a worksheet tab from a reference cell
  • Finance Guru
Replies
2
Views
313K
Luke M
L
M
Excel 2007 -->> SUMIFS v SUMPRODUCT
  • MurrayBarn
Replies
4
Views
453K
Jacob Skaria
J
J
Cell value determined by the current time and date
  • jschae
Replies
2
Views
138K
Jacob Skaria
J
M
Problem with Syntax?
  • MurrayBarn
Replies
8
Views
857K
MurrayBarn
M
B
Go to a chosen worksheet
  • Bob
Replies
1
Views
372K
Jacob Skaria
J
T
macro to grab current workbook filename
  • TR Young
Replies
3
Views
50K
Eduardo
E
E
Help: Assigning a "word" a numerical value
  • Eric
Replies
1
Views
170K
Jacob Skaria
J
L
Less than, Greater Than, equal to conditional formatting
  • Lee West
Replies
4
Views
583K
Lee West
L
L
Hiding columns in Excel 2003
  • Les
Replies
2
Views
418K
Harlan Grove
H
D
inverse weighted average
  • Dan Cotts
Replies
2
Views
460K
Harlan Grove
H
D
Inverse wieghted average/ratio
  • dtacotts
Replies
1
Views
274K
Jim Cone
J
F
Sums including #NAME?
  • Fred Holmes
Replies
2
Views
242K
Fred Holmes
F
E
Trying to highlight cells that have the same value as the active c
  • Excel_Rookie
Replies
9
Views
272K
Jacob Skaria
J
C
Remove last n rows
  • Colin Hayes
Replies
6
Views
598K
Colin Hayes
C
P
count number of occurances between 2 values
  • Peters
Replies
2
Views
315K
Max
M
L
Sort Block of Data
  • lab-guy
Replies
3
Views
253K
CLR
C
E
Sumproduct with blanks
  • EZ
Replies
9
Views
683K
EZ
E
T
Eliminating Duplicates in Excel 2007
  • Té
Replies
2
Views
111K
Té
T
You must log in or register to post here.
Back
Top