Microsoft Excel Worksheet Functions

A
Auto enter current date in cell when another changed
  • Andy Smith
Replies
7
Views
207K
kgood1
K
C
Constructing Range Name calls with Concatenate
  • CellShocked
Replies
4
Views
484K
Pete_UK
P
C
How do I have a cell value define a dynamic named range?
  • CellShocked
Replies
15
Views
992K
CellShocked
C
C
Excel Macro or Formula Question
  • carl
Replies
1
Views
106K
isabelle
I
C
Global Change Of Formula Value
  • carl
Replies
2
Views
304K
Don Guillett
D
C
need help extracting data from cell....
  • Chris Persheff
Replies
4
Views
361K
Don Guillett
D
M
Formula Using Vlookup & Match
  • ms.maryw
Replies
3
Views
389K
Pete_UK
P
G
excel should have a function to count sheets
  • Guest
Replies
8
Views
102K
uloveonce
U
S
I have a column of numbers, all are positive.
  • Skip
Replies
3
Views
124K
tb
T
R
Vlookup for repitative data
  • Raju
Replies
8
Views
214K
Raju
R
A
Conditional Formatting Formula
  • AJT82
Replies
1
Views
221K
AJT82
A
D
Highlight row
  • dave
Replies
3
Views
333K
Claus Busch
C
A
Adding values for all rows in a range
  • Alvaro
Replies
6
Views
539K
Claus Busch
C
P
return proper match from three columns
  • plus766
Replies
2
Views
330K
Pete_UK
P
W
Vlookup error
  • wesley holtman
Replies
1
Views
240K
Dave Peterson
D
R
Lookup Formula
  • Rafeek
Replies
4
Views
386K
Bartt
B
J
Mixed numerical and textual data
  • jimbo
Replies
4
Views
428K
Xt
X
E
Cell format
  • Esradekan
Replies
3
Views
173K
isabelle
I
G
SUMIFS, one criteria range, multiple criteria
  • GavinS
Replies
3
Views
583K
Yahya Hussien
Y
C
Lookup across a Range
  • Commish
Replies
1
Views
70K
Commish
C
D
Icon sets fomatting error
  • da_ledge
Replies
0
Views
99K
da_ledge
D
N
Excel Split column data
  • N_C_manning
Replies
0
Views
201K
N_C_manning
N
W
Use array/braces **WITHIN** a formula?
  • wal
Replies
3
Views
331K
wal
W
M
HELP! Single cell formula to calculate weeks cover of stock on forward sales.
  • matthew.webb
Replies
3
Views
246K
Aidan Arkinson
A
A
eliminate negative value from normal random number distribution
  • Ahmad
Replies
4
Views
754K
joeu2004
J
D
How to use If and And function in a worksheet
  • dingtang
Replies
0
Views
190K
dingtang
D
P
code to unhide tabs based on cell contents
  • pat67
Replies
7
Views
531K
isabelle
I
K
Possible to refer to a sheet's object name ?
  • kittronald
Replies
1
Views
252K
Don Guillett
D
R
divide numbers up for a paper form
  • Revenue
Replies
2
Views
230K
Don Guillett
D
K
Does the order of worksheets matter ?
  • kittronald
Replies
1
Views
176K
Don Guillett
D
E
Count values, excluding duplicates and specific values
  • eaemeric
Replies
2
Views
235K
eaemeric
E
J
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS
  • Jim
Replies
1
Views
308K
isabelle
I
P
formatting a percentage in a cell
  • pat67
Replies
1
Views
173K
pat67
P
A
Formula for function/argument "exclude".
  • arvindraut18
Replies
0
Views
277K
arvindraut18
A
R
Formula help
  • rjyoung00
Replies
0
Views
186K
rjyoung00
R
C
Replace a fixed number with a variable via popup
  • Colin Hayes
Replies
3
Views
211K
Gord
G
M
Using COUNTIF with criteria in an adjacent column?
  • Mr Molio
Replies
5
Views
359K
Mr Molio
M
S
convert amount to denominations
  • Suzanne Mead
Replies
13
Views
253K
dcolvard
D
R
Split words in a cell
  • Rafeek
Replies
4
Views
428K
m.m.ahmed
M
T
SumByColor & #NAME?
  • Ty
Replies
7
Views
90K
Gord
G
J
Skipping weekends during a count
  • justaj
Replies
1
Views
102K
justaj
J
T
How to get range names to Apply across multiple tabs
  • TrippKnightly
Replies
1
Views
304K
isabelle
I
G
how do i use the markowitz method with solver?
  • Guest
Replies
2
Views
199K
tyrian
T
T
Calculating Sortino Ration (Downside Deviation)
  • TimH
Replies
9
Views
811K
tyrian
T
T
running clock
  • Ted
Replies
4
Views
85K
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
364K
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
264K
joeu2004
J
B
The effects of time on value
  • B~O~B
Replies
1
Views
270K
joeu2004
J
R
GST
  • rhhince
Replies
3
Views
166K
Rich/rerat
R
D
activity
  • Don Guillett
Replies
1
Views
65K
Gord
G
You must log in or register to post here.
Back
Top