Excel Functions

Post thread
K
Calculating Standard Deviation while ignoring Zeros
  • kendrickmr
Replies
1
Views
9K
Harlan Grove
H
F
concatenate parts of a cell
  • fred.preston
Replies
2
Views
7K
[email protected]
F
M
LINEST with TRANSPOSE
  • mike hutchins
Replies
1
Views
5K
Harlan Grove
H
G
SumProduct and excluding specific cells
  • Gunjani
Replies
1
Views
4K
Harlan Grove
H
M
Dynamic reference in Offset-function for Define Names, Refers to.
  • mange_hit
Replies
2
Views
3K
[email protected]
M
B
Harlan Grove's Pull function with Closed workbooks
  • bertowall
Replies
0
Views
3K
bertowall
B
T
Count unique values based on a condition
  • TFTAJLLYMXZP
Replies
3
Views
2K
Hoss
H
Y
Reverse INDEX MATCH
  • Yunus
Replies
0
Views
2K
Yunus
Y
U
If statement formulas
  • Unknown Soldier
Replies
9
Views
2K
Unknown Soldier
U
R
VAre Fractions allowed in VLookup Tables or must they be converedtedfor useage?
  • Realitygdk
Replies
2
Views
2K
[email protected]
R
S
count by color in excel 2007
  • sblanky
Replies
1
Views
2K
Harlan Grove
H
J
BEST WAY TO LEARN HOW TO CREATE MACRO?
  • Jenny
Replies
2
Views
2K
admin
A
L
Update cell value based on name and specific date
  • Leo1111
Replies
0
Views
2K
Leo1111
L
V
Addin subclusters
  • vjp2.at
Replies
1
Views
2K
[email protected]
V
D
Spreadsheet Corruption?
  • dennis
Replies
4
Views
2K
dennis
D
V
1..10 array
  • vjp2.at
Replies
1
Views
2K
PETER.MCQUILLAN
P
U
SORTING BETWEEN WORKSHEETS
  • Unknown Soldier
Replies
6
Views
2K
Rich/rerat
R
S
Text upside down!
  • stevewy
Replies
4
Views
2K
Dave Peterson
D
C
Chronologically collate comments from several spreadsheets - help needed.
  • Chris Mitchell
Replies
0
Views
2K
Chris Mitchell
C
D
Auto Execute Macro
  • dennis
Replies
2
Views
2K
dennis
D
Y
Filters - Unique Records
  • Yunus
Replies
0
Views
2K
Yunus
Y
U
Or, index, match statements
  • Unknown Soldier
Replies
1
Views
2K
T. Valko
T
P
Sorting in Excel
  • PETER.MCQUILLAN
Replies
0
Views
2K
PETER.MCQUILLAN
P
D
XBRL Tool
  • dennis
Replies
0
Views
2K
dennis
D
Y
IF satement fo in between dates
  • Yunus
Replies
0
Views
2K
Yunus
Y
Y
Conditional Format IF statement
  • Yunus
Replies
0
Views
2K
Yunus
Y
D
how to test if a check box is checked
  • dan
Replies
3
Views
2K
dan
D
B
worksheet function to return index of largest value
  • bmurphy
Replies
1
Views
2K
Pete_UK
P
L
Looking up a value
  • lukedall
Replies
0
Views
2K
[email protected]
L
F
countifs function
  • Felsa Satlow
Replies
3
Views
2K
ilia
I
B
This function works for small figures but not for large
  • Bob H
Replies
0
Views
2K
Bob H
B
C
Spell Check function in an IF statement?
  • cmotes
Replies
2
Views
2K
ilia
I
P
Dynamic pointing to a cell
  • pablito
Replies
0
Views
2K
pablito
P
N
Applying 1 formula to multiple cells simultaneously
  • nonapp2
Replies
2
Views
2K
nonapp2
N
J
formula for a formula
  • JOhn Smith
Replies
1
Views
2K
mrorwell
M
A
HELP !!
  • Atty
Replies
0
Views
2K
Atty
A
J
SUMIF or SUMIFS
  • Jeff
Replies
3
Views
2K
ilia
I
B
Hyperlinks fail when constructed using Autofil
  • Bushy
Replies
0
Views
2K
Bushy
B
I
sumproduct returning odd results
  • iccrew98
Replies
1
Views
2K
Pete_UK
P
L
Goal Seek error?? 2007
  • LewCousineau
Replies
0
Views
2K
[email protected]
L
U
Sort
  • Unknown Soldier
Replies
1
Views
2K
Max
M
M
Something like VLOOKUP
  • Martin
Replies
1
Views
2K
Sasa Stankovic
S
M
XLSX to XL
  • Mario
Replies
0
Views
1K
Mario
M
V
can I replace 4,4,4 with 4*{1,1,1} in IRR & NPV
  • vjp2.at
Replies
0
Views
1K
[email protected]
V
R
Creating worksheets
  • rennier.coetzee
Replies
1
Views
1K
ilia
I
N
REQ: Scanning directly into Excel
  • nonapp2
Replies
1
Views
1K
Sasa Stankovic
S
E
Run a macro depending on cell value
  • Esradekan
Replies
2
Views
1K
ilia
I
A
Date Difference
  • Art Wrok
Replies
1
Views
1K
Mangesh
M
C
Create A Unique List From Multiple Tabs Using Formula
  • calummurdo
Replies
0
Views
1K
[email protected]
C
S
VLOOKUP only works when =Today() is used in formula, no other dates
  • Shawn Morneau
Replies
1
Views
1K
NoodNutt
N
Top