Microsoft Excel Worksheet Functions

Post thread
A
Auto enter current date in cell when another changed
  • Andy Smith
Replies
7
Views
2K
kgood1
K
C
Constructing Range Name calls with Concatenate
  • CellShocked
Replies
4
Views
1K
Pete_UK
P
C
How do I have a cell value define a dynamic named range?
  • CellShocked
Replies
15
Views
1K
CellShocked
C
C
Excel Macro or Formula Question
  • carl
Replies
1
Views
609
isabelle
I
C
Global Change Of Formula Value
  • carl
Replies
2
Views
579
Don Guillett
D
C
need help extracting data from cell....
  • Chris Persheff
Replies
4
Views
625
Don Guillett
D
M
Formula Using Vlookup & Match
  • ms.maryw
Replies
3
Views
805
Pete_UK
P
G
excel should have a function to count sheets
  • Guest
Replies
8
Views
15K
uloveonce
U
S
I have a column of numbers, all are positive.
  • Skip
Replies
3
Views
588
tb
T
R
Vlookup for repitative data
  • Raju
Replies
8
Views
924
Raju
R
A
Conditional Formatting Formula
  • AJT82
Replies
1
Views
649
AJT82
A
D
Highlight row
  • dave
Replies
3
Views
608
Claus Busch
C
A
Adding values for all rows in a range
  • Alvaro
Replies
6
Views
612
Claus Busch
C
P
return proper match from three columns
  • plus766
Replies
2
Views
921
Pete_UK
P
W
Vlookup error
  • wesley holtman
Replies
1
Views
699
Dave Peterson
D
R
Lookup Formula
  • Rafeek
Replies
4
Views
913
Bartt
B
J
Mixed numerical and textual data
  • jimbo
Replies
4
Views
898
Xt
X
E
Cell format
  • Esradekan
Replies
3
Views
868
isabelle
I
G
SUMIFS, one criteria range, multiple criteria
  • GavinS
Replies
3
Views
3K
Yahya Hussien
Y
C
Lookup across a Range
  • Commish
Replies
1
Views
560
Commish
C
D
Icon sets fomatting error
  • da_ledge
Replies
0
Views
668
da_ledge
D
N
Excel Split column data
  • N_C_manning
Replies
0
Views
709
N_C_manning
N
W
Use array/braces **WITHIN** a formula?
  • wal
Replies
3
Views
886
wal
W
M
HELP! Single cell formula to calculate weeks cover of stock on forward sales.
  • matthew.webb
Replies
3
Views
12K
Aidan Arkinson
A
A
eliminate negative value from normal random number distribution
  • Ahmad
Replies
4
Views
10K
joeu2004
J
D
How to use If and And function in a worksheet
  • dingtang
Replies
0
Views
601
dingtang
D
P
code to unhide tabs based on cell contents
  • pat67
Replies
7
Views
2K
isabelle
I
K
Possible to refer to a sheet's object name ?
  • kittronald
Replies
1
Views
791
Don Guillett
D
R
divide numbers up for a paper form
  • Revenue
Replies
2
Views
691
Don Guillett
D
K
Does the order of worksheets matter ?
  • kittronald
Replies
1
Views
956
Don Guillett
D
E
Count values, excluding duplicates and specific values
  • eaemeric
Replies
2
Views
766
eaemeric
E
J
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS
  • Jim
Replies
1
Views
2K
isabelle
I
P
formatting a percentage in a cell
  • pat67
Replies
1
Views
575
pat67
P
A
Formula for function/argument "exclude".
  • arvindraut18
Replies
0
Views
776
arvindraut18
A
R
Formula help
  • rjyoung00
Replies
0
Views
582
rjyoung00
R
C
Replace a fixed number with a variable via popup
  • Colin Hayes
Replies
3
Views
951
Gord
G
M
Using COUNTIF with criteria in an adjacent column?
  • Mr Molio
Replies
5
Views
5K
Mr Molio
M
S
convert amount to denominations
  • Suzanne Mead
Replies
13
Views
1K
dcolvard
D
R
Split words in a cell
  • Rafeek
Replies
4
Views
771
m.m.ahmed
M
T
SumByColor & #NAME?
  • Ty
Replies
7
Views
3K
Gord
G
J
Skipping weekends during a count
  • justaj
Replies
1
Views
560
justaj
J
T
How to get range names to Apply across multiple tabs
  • TrippKnightly
Replies
1
Views
668
isabelle
I
G
how do i use the markowitz method with solver?
  • Guest
Replies
2
Views
7K
tyrian
T
T
Calculating Sortino Ration (Downside Deviation)
  • TimH
Replies
9
Views
8K
tyrian
T
T
running clock
  • Ted
Replies
4
Views
662
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
760
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
615
joeu2004
J
B
The effects of time on value
  • B~O~B
Replies
1
Views
510
joeu2004
J
R
GST
  • rhhince
Replies
3
Views
640
Rich/rerat
R
D
activity
  • Don Guillett
Replies
1
Views
442
Gord
G
Back
Top