Microsoft Excel Worksheet Functions

Post thread
J
Protect selected settings in 'options'
  • John
Replies
4
Views
356
Harlan Grove
H
R
Extracting information to automatically find previous value.
  • Rocko
Replies
3
Views
414
T. Valko
T
F
"AverageIf"
  • fozzie888
Replies
2
Views
466
Shane Devenshire
S
L
Sum Of Last Two Entries in Rotating Columns
  • Loadmaster
Replies
6
Views
627
T. Valko
T
A
How do i stop Excel from turning a value into a formula?
  • Annetoinette
Replies
3
Views
54K
Dave Peterson
D
O
Divide by the minimum non-zero number in a range of cells
  • Opus
2
Replies
21
Views
2K
JoeU2004
J
L
Conditional Currency
  • Loadmaster
Replies
5
Views
369
Allllen
A
K
max value from multiple rows of similar information
  • Karesel
Replies
5
Views
520
T. Valko
T
D
runtime error 2147221005(800401f3)
  • deen
Replies
1
Views
2K
JLatham
J
S
repeated values
  • sood
Replies
1
Views
378
Allllen
A
A
YEAR MONTH DAYS COUNTER
  • ad2ad79
Replies
6
Views
1K
Don Guillett
D
A
Max Min Differnce in a Range
  • Albert H. Bell
Replies
6
Views
647
Albert H. Bell
A
C
2003 Excel
  • CC Bulinski
Replies
2
Views
257
Bernard Liengme
B
R
If part of a cell = "NVA" then insert "Norfolk" in return cell
  • RNCKWMN
Replies
4
Views
623
Francis
F
A
Number of total calculation functions
  • appsinoffice2003
Replies
3
Views
411
Shane Devenshire
S
D
Excell rank= I need to reverse the order
  • Dennis Noble
Replies
2
Views
469
Shane Devenshire
S
B
Dependent List "Index" Problem
  • Benjamin
Replies
2
Views
417
Benjamin
B
L
cell formulas
  • Lynn
Replies
3
Views
370
Gord Dibben
G
J
convert hours and minutes into days
  • Joshua
Replies
2
Views
4K
JE McGimpsey
J
P
Excel cannot complete this task with available resources
  • PSM
Replies
1
Views
2K
Bob Bridges
B
A
Sumif or Sumproduct?
  • alarson01
Replies
2
Views
416
Bassman62
B
J
How do I change the default header date format in Excel 2007?
  • Jazzman721
Replies
3
Views
12K
Gord Dibben
G
R
Count Unique Values
  • Richard
Replies
7
Views
412
T. Valko
T
D
DSUM - Need dynamic functionality
  • Don
Replies
8
Views
2K
Harlan Grove
H
D
Data comparison for duplication
  • Donna
Replies
1
Views
393
Shane Devenshire
S
I
Conditional Formatting
  • it''''''''sh hardy
Replies
4
Views
291
it''''''''sh hardy
I
J
IF formula for time
  • Joshua
Replies
6
Views
359
T. Valko
T
J
Difference between date and time
  • Joshua
Replies
7
Views
715
Rich/rerat
R
S
How to replace a formula string with * in the leading position?
  • Seaq
Replies
3
Views
1K
T. Valko
T
S
Index with mulitple value returns and muliple column returns
  • solar+CSE
Replies
4
Views
1K
T. Valko
T
I
Delete BOTH sets duplicate data in columns (debits/credits)
  • Iamconstance
Replies
1
Views
685
Bernie Deitrick
B
C
how do I view up to 120,000 rows in office excel 2003
  • Chikanox
Replies
2
Views
737
Bernard Liengme
B
R
change cell colour according to date.....
  • RichLive
Replies
2
Views
1K
Bernard Liengme
B
F
Naming a worksheet tab from a reference cell
  • Finance Guru
Replies
2
Views
626
Luke M
L
M
Excel 2007 -->> SUMIFS v SUMPRODUCT
  • MurrayBarn
Replies
4
Views
2K
Jacob Skaria
J
J
Cell value determined by the current time and date
  • jschae
Replies
2
Views
473
Jacob Skaria
J
M
Problem with Syntax?
  • MurrayBarn
Replies
8
Views
640
MurrayBarn
M
B
Go to a chosen worksheet
  • Bob
Replies
1
Views
401
Jacob Skaria
J
T
macro to grab current workbook filename
  • TR Young
Replies
3
Views
574
Eduardo
E
E
Help: Assigning a "word" a numerical value
  • Eric
Replies
1
Views
380
Jacob Skaria
J
L
Less than, Greater Than, equal to conditional formatting
  • Lee West
Replies
4
Views
4K
Lee West
L
L
Hiding columns in Excel 2003
  • Les
Replies
2
Views
378
Harlan Grove
H
D
inverse weighted average
  • Dan Cotts
Replies
2
Views
9K
Harlan Grove
H
D
Inverse wieghted average/ratio
  • dtacotts
Replies
1
Views
910
Jim Cone
J
F
Sums including #NAME?
  • Fred Holmes
Replies
2
Views
393
Fred Holmes
F
E
Trying to highlight cells that have the same value as the active c
  • Excel_Rookie
Replies
9
Views
2K
Jacob Skaria
J
C
Remove last n rows
  • Colin Hayes
Replies
6
Views
453
Colin Hayes
C
P
count number of occurances between 2 values
  • Peters
Replies
2
Views
424
Max
M
L
Sort Block of Data
  • lab-guy
Replies
3
Views
297
CLR
C
E
Sumproduct with blanks
  • EZ
Replies
9
Views
815
EZ
E
Back
Top