Microsoft Excel Worksheet Functions

Post thread
J
Can I create a 3-D reference from multiple workbooks
  • Jennifer
Replies
2
Views
398
Gord Dibben
G
D
How do I get rid of expired links
  • Dave Schreffler
Replies
3
Views
661
Gord Dibben
G
A
Timesheets for Overnight work
  • altonomus
Replies
0
Views
373
altonomus
A
C
Formula to pull first word from text string in a column
  • CrisT
Replies
12
Views
755
T. Valko
T
S
in the drop down filter box how do you increase font size?
  • Stevie
Replies
1
Views
965
Gord Dibben
G
M
Cross Reference Formula
  • mjsam
Replies
2
Views
399
Mike H
M
S
automatic formula
  • samus
Replies
2
Views
390
Gord Dibben
G
V
Formula to look up from another tab
  • Voodoo
Replies
3
Views
415
Shane Devenshire
S
M
Abrupt change in formula results using sumproduct
  • mbeemom
Replies
4
Views
518
mbeemom
M
L
Format cells and font by content/whether formula present
  • LJT87
Replies
2
Views
466
Gord Dibben
G
B
How to freeze 1 or more CELLS in spreadsheet?
  • Bigdog
Replies
5
Views
477
Gord Dibben
G
N
deleting the first 2 digits of number in a cell
  • NoviceMALGER
Replies
2
Views
376
Pete_UK
P
L
Get "####" when use alpha char in a cell referenced by a formula
  • Leo
Replies
5
Views
405
Chip Pearson
C
J
data
  • JAY
Replies
1
Views
708
Gary''s Student
G
R
Calculate the number of weeksdays based on a cell value
  • roniaelm
Replies
8
Views
502
T. Valko
T
R
Automatic invoicing numbers
  • Riaan Welman
Replies
2
Views
449
xlm
X
E
Help with percentages
  • Excelnew
Replies
1
Views
424
Pete_UK
P
M
Cross Reference Formula
  • mjsam
Replies
2
Views
464
Pete_UK
P
T
Creating Spreadsheets
  • terry
Replies
1
Views
291
terry
T
M
Conditional sum wizard
  • Martin G
Replies
1
Views
437
Pete_UK
P
S
Fill Lock!
  • SteffenAndreassen
Replies
1
Views
375
Luke M
L
J
Count occurences of a letter in a cell
  • Jair Batista
Replies
2
Views
454
Jair Batista
J
N
searching for a function
  • Noha
Replies
7
Views
258
Pete_UK
P
M
use date formula to update workbook in real time
  • Michael
Replies
1
Views
299
Niek Otten
N
G
Automatically incrementing number for each print
  • Guest
Replies
7
Views
668
LiAD
L
L
Printing
  • LiAD
Replies
1
Views
389
LiAD
L
M
Printing
  • Marianne
Replies
4
Views
466
LiAD
L
M
sumproduct with duplicates in two columns
  • MAANI
Replies
7
Views
536
Bob Phillips
B
S
How to Copy range of Row heights from one sheet to another in XL?
  • Suby Mathews
Replies
1
Views
459
Max
M
D
Index & Match
  • Dewayne
Replies
3
Views
397
Max
M
T
Change from american date entry format
  • The Fru Fru
Replies
1
Views
417
Gaby
G
E
value of first visible cell
  • Eddy Stan
Replies
4
Views
514
T. Valko
T
P
SUMIF / SUMPRODUCT
  • PetalNyeri
Replies
1
Views
526
T. Valko
T
G
Adding columns using dates, but getting wrong data
  • Griffey5
Replies
3
Views
564
T. Valko
T
D
Advanced Filter used with merged cells?
  • davisk
Replies
1
Views
2K
davisk
D
K
change phone no. from ###-###-#### to (###) ###-####
  • KarinS
Replies
1
Views
323
Pete_UK
P
B
"###" instead of a sum
  • Bea
Replies
2
Views
353
Bea
B
E
Function IF and OR together
  • Eli
Replies
2
Views
464
joeu2004
J
S
Sum Wrong total but add each cell gives the correct total
  • Steved
Replies
6
Views
976
Max
M
J
automatic number sequencing?
  • Joe the exceler
Replies
1
Views
466
FSt1
F
A
columns_if
  • Alexandra Lopes
Replies
7
Views
365
Bob Phillips
B
B
Split payments
  • Bebe
Replies
8
Views
548
Max
M
P
Need a formula
  • pattigail1960
Replies
7
Views
339
T. Valko
T
M
IF and Lookup
  • Martinc126
Replies
5
Views
409
T. Valko
T
S
using automatic dates in cells
  • shereea_1
Replies
2
Views
314
Mike H
M
K
Conditional Formating
  • Kath
Replies
6
Views
397
Kath
K
B
If statement not returning the value i need
  • barbi b
Replies
6
Views
479
Fred Smith
F
T
Read only
  • tdw
Replies
2
Views
381
Michael
M
P
Date issue
  • Patrick C. Simonds
Replies
6
Views
304
Shane Devenshire
S
M
Formula refresh
  • Marcus
Replies
6
Views
506
Gord Dibben
G
Back
Top