Microsoft Excel Worksheet Functions

Post thread
M
date in text format as a real date
  • Mortir
Replies
2
Views
398
Gord Dibben
G
M
frequency/sort/sumproduct
  • mass
Replies
3
Views
545
mass
M
C
Help needed with a calculation question
  • CP
Replies
6
Views
368
Bernie Deitrick
B
L
Summary of data in excel
  • Lozza65
Replies
3
Views
376
excelent
E
M
sumproduct text if
  • mass
Replies
8
Views
697
Sandy Mann
S
S
active cell address with worksheet function
  • Stefi
Replies
3
Views
460
Stefi
S
B
Highlight cells with certain number values
  • Betsy
Replies
1
Views
300
Don Guillett
D
K
How to link a drop down menu to another one?
  • Khaledity
Replies
1
Views
308
Stephen
S
S
Auto Filter
  • stremetzky
Replies
4
Views
331
stremetzky
S
L
Excel Inport External Data - new queries
  • Lozza65
Replies
1
Views
340
FSt1
F
T
Using IF function then Autofill-increments down a reference cell
  • Twinspot
Replies
2
Views
1K
Twinspot
T
J
How to sort column data regardless of col length
  • JBW
Replies
2
Views
552
JBW
J
M
100*50 to =100*50
  • Mortir
Replies
3
Views
605
Lori
L
E
How to convert CVS into XLS
  • elhossan
Replies
1
Views
499
Pete_UK
P
G
VLOOKUP formula question
  • Gmata
Replies
3
Views
230
Pete_UK
P
A
make it 12 rows from 1 row
  • AskExcel
Replies
1
Views
318
carlo
C
D
How to get last amount in a column
  • drumz
Replies
8
Views
395
David Biddulph
D
K
swap values between two cells
  • killdare
Replies
3
Views
544
carlo
C
W
INDEX MATCH #N/A Error
  • wkjgmom
Replies
3
Views
470
T. Valko
T
B
wild card in sumproduct
  • BNT1 via OfficeKB.com
Replies
3
Views
876
T. Valko
T
G
Line up rows to corresponding row of larger master list in excel
  • Guest
Replies
13
Views
532
lospeirs
L
J
Identifying cells without certain text strings
  • jay
Replies
3
Views
418
Teethless mama
T
L
Multiple Functions
  • Linar33
Replies
4
Views
548
Teethless mama
T
G
worksheet function to summarise a list of text?
  • Guest
Replies
9
Views
727
Don Guillett
D
T
SUMPRODUCT HELP
  • tina
Replies
6
Views
394
Max
M
D
formula to change font or cell colour
  • Dave
Replies
3
Views
977
Pete_UK
P
M
How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank
  • Mike
Replies
3
Views
349
T. Valko
T
V
trailing minus
  • via135
Replies
10
Views
661
via135
V
G
WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0)
  • GEORGE ZEIGLER, SAN DIEGO
Replies
7
Views
561
GEORGE ZEIGLER, SAN DIEGO
G
B
sumproduct with indirect
  • BNT1 via OfficeKB.com
Replies
5
Views
663
vezerid
V
B
#VALUE! error message help needed please
  • Bob Newman
Replies
3
Views
335
Bob Newman
B
D
Conditional List
  • Debbiejj
Replies
3
Views
336
RAGdyer
R
R
I want to do Autosum by pressing "Alt=", instead I get 3/4. Why?
  • Ramona
Replies
2
Views
351
Ramona
R
T
Comparing times..
  • trapani81
Replies
1
Views
407
Fred Smith
F
G
How can i Recall a Value?
  • Gmata
Replies
1
Views
300
Alan
A
M
FILTER (REPEATED NUMBERS)
  • M. Farooq
Replies
1
Views
274
Max
M
G
#REF error in named formula
  • Gene
Replies
2
Views
363
Dave Peterson
D
M
Changing to a usable format - number
  • Mortir
Replies
1
Views
373
Mortir
M
V
excel clear button
  • vdmbqb
Replies
1
Views
710
Fred Smith
F
A
Help with a lookup
  • ajnmx
Replies
2
Views
332
Herbert Seidenberg
H
S
PivotTable - Show labels on every row?
  • S Davis
Replies
1
Views
2K
Debra Dalgleish
D
L
HOW DO I CONVERT LOTUS 123 (ON DOS) TO EXCELL?
  • LOTUS/EXCELL
Replies
2
Views
806
FSt1
F
O
Preventing printing
  • ordnance1
Replies
1
Views
397
Bernie Deitrick
B
G
excel golf scores, how do I add the scores for all par 3's etc
  • Golf Analyst
Replies
2
Views
997
Fred Smith
F
D
Named Ranges Not Working in Data Validation
  • dplum
Replies
8
Views
684
Spike9458
S
M
How can I creat userdefine function
  • Montu
Replies
7
Views
733
Montu
M
C
replace error with blank
  • chegel
Replies
7
Views
391
chegel
C
O
countif
  • old coach
Replies
1
Views
324
T. Valko
T
R
Find Row in a named range
  • Raul
Replies
3
Views
452
Pete_UK
P
H
Data Form, Macro and Countif
  • helen wheels
Replies
1
Views
315
Pete_UK
P
Back
Top