Microsoft Excel Worksheet Functions

M
frequency/sort/sumproduct
  • mass
Replies
3
Views
122K
mass
M
C
Help needed with a calculation question
  • CP
Replies
6
Views
272K
Bernie Deitrick
B
L
Summary of data in excel
  • Lozza65
Replies
3
Views
294K
excelent
E
M
sumproduct text if
  • mass
Replies
8
Views
234K
Sandy Mann
S
S
active cell address with worksheet function
  • Stefi
Replies
3
Views
212K
Stefi
S
B
Highlight cells with certain number values
  • Betsy
Replies
1
Views
54K
Don Guillett
D
K
How to link a drop down menu to another one?
  • Khaledity
Replies
1
Views
129K
Stephen
S
S
Auto Filter
  • stremetzky
Replies
4
Views
361K
stremetzky
S
L
Excel Inport External Data - new queries
  • Lozza65
Replies
1
Views
75K
FSt1
F
T
Using IF function then Autofill-increments down a reference cell
  • Twinspot
Replies
2
Views
515K
Twinspot
T
J
How to sort column data regardless of col length
  • JBW
Replies
2
Views
334K
JBW
J
M
100*50 to =100*50
  • Mortir
Replies
3
Views
45K
Lori
L
E
How to convert CVS into XLS
  • elhossan
Replies
1
Views
381K
Pete_UK
P
G
VLOOKUP formula question
  • Gmata
Replies
3
Views
129K
Pete_UK
P
A
make it 12 rows from 1 row
  • AskExcel
Replies
1
Views
130K
carlo
C
D
How to get last amount in a column
  • drumz
Replies
8
Views
247K
David Biddulph
D
K
swap values between two cells
  • killdare
Replies
3
Views
123K
carlo
C
W
INDEX MATCH #N/A Error
  • wkjgmom
Replies
3
Views
325K
T. Valko
T
B
wild card in sumproduct
  • BNT1 via OfficeKB.com
Replies
3
Views
380K
T. Valko
T
G
Line up rows to corresponding row of larger master list in excel
  • Guest
Replies
13
Views
364K
lospeirs
L
J
Identifying cells without certain text strings
  • jay
Replies
3
Views
48K
Teethless mama
T
L
Multiple Functions
  • Linar33
Replies
4
Views
29K
Teethless mama
T
G
worksheet function to summarise a list of text?
  • Guest
Replies
9
Views
548K
Don Guillett
D
T
SUMPRODUCT HELP
  • tina
Replies
6
Views
318K
Max
M
D
formula to change font or cell colour
  • Dave
Replies
3
Views
462K
Pete_UK
P
M
How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank
  • Mike
Replies
3
Views
229K
T. Valko
T
V
trailing minus
  • via135
Replies
10
Views
624K
via135
V
G
WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0)
  • GEORGE ZEIGLER, SAN DIEGO
Replies
7
Views
243K
GEORGE ZEIGLER, SAN DIEGO
G
B
sumproduct with indirect
  • BNT1 via OfficeKB.com
Replies
5
Views
363K
vezerid
V
B
#VALUE! error message help needed please
  • Bob Newman
Replies
3
Views
373K
Bob Newman
B
D
Conditional List
  • Debbiejj
Replies
3
Views
122K
RAGdyer
R
R
I want to do Autosum by pressing "Alt=", instead I get 3/4. Why?
  • Ramona
Replies
2
Views
64K
Ramona
R
T
Comparing times..
  • trapani81
Replies
1
Views
256K
Fred Smith
F
G
How can i Recall a Value?
  • Gmata
Replies
1
Views
61K
Alan
A
M
FILTER (REPEATED NUMBERS)
  • M. Farooq
Replies
1
Views
51K
Max
M
G
#REF error in named formula
  • Gene
Replies
2
Views
142K
Dave Peterson
D
M
Changing to a usable format - number
  • Mortir
Replies
1
Views
305K
Mortir
M
V
excel clear button
  • vdmbqb
Replies
1
Views
129K
Fred Smith
F
A
Help with a lookup
  • ajnmx
Replies
2
Views
181K
Herbert Seidenberg
H
S
PivotTable - Show labels on every row?
  • S Davis
Replies
1
Views
222K
Debra Dalgleish
D
L
HOW DO I CONVERT LOTUS 123 (ON DOS) TO EXCELL?
  • LOTUS/EXCELL
Replies
2
Views
206K
FSt1
F
O
Preventing printing
  • ordnance1
Replies
1
Views
377K
Bernie Deitrick
B
G
excel golf scores, how do I add the scores for all par 3's etc
  • Golf Analyst
Replies
2
Views
362K
Fred Smith
F
D
Named Ranges Not Working in Data Validation
  • dplum
Replies
8
Views
197K
Spike9458
S
M
How can I creat userdefine function
  • Montu
Replies
7
Views
827K
Montu
M
C
replace error with blank
  • chegel
Replies
7
Views
326K
chegel
C
O
countif
  • old coach
Replies
1
Views
82K
T. Valko
T
R
Find Row in a named range
  • Raul
Replies
3
Views
149K
Pete_UK
P
H
Data Form, Macro and Countif
  • helen wheels
Replies
1
Views
173K
Pete_UK
P
D
calculating number of days between first day to last day, inclusiv
  • Damian
Replies
1
Views
109K
JE McGimpsey
J
You must log in or register to post here.
Back
Top