Microsoft Excel Worksheet Functions

Post thread
J
Conditional sum, when condition has multiple values
  • jkr
Replies
3
Views
839
[email protected]
J
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
2K
CellShocked
C
C
Excel Macro or Formula Question
  • carl
Replies
1
Views
627
isabelle
I
C
Global Change Of Formula Value
  • carl
Replies
2
Views
596
Don Guillett
D
C
need help extracting data from cell....
  • Chris Persheff
Replies
4
Views
665
Don Guillett
D
M
Formula Using Vlookup & Match
  • ms.maryw
Replies
3
Views
828
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
607
tb
T
R
Vlookup for repitative data
  • Raju
Replies
8
Views
959
Raju
R
A
Conditional Formatting Formula
  • AJT82
Replies
1
Views
682
AJT82
A
D
Highlight row
  • dave
Replies
3
Views
634
Claus Busch
C
A
Adding values for all rows in a range
  • Alvaro
Replies
6
Views
660
Claus Busch
C
P
return proper match from three columns
  • plus766
Replies
2
Views
971
Pete_UK
P
W
Vlookup error
  • wesley holtman
Replies
1
Views
734
Dave Peterson
D
R
Lookup Formula
  • Rafeek
Replies
4
Views
975
Bartt
B
J
Mixed numerical and textual data
  • jimbo
Replies
4
Views
938
Xt
X
E
Cell format
  • Esradekan
Replies
3
Views
900
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
568
Commish
C
D
Icon sets fomatting error
  • da_ledge
Replies
0
Views
680
da_ledge
D
N
Excel Split column data
  • N_C_manning
Replies
0
Views
719
N_C_manning
N
W
Use array/braces **WITHIN** a formula?
  • wal
Replies
3
Views
936
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
614
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
818
Don Guillett
D
R
divide numbers up for a paper form
  • Revenue
Replies
2
Views
717
Don Guillett
D
K
Does the order of worksheets matter ?
  • kittronald
Replies
1
Views
983
Don Guillett
D
E
Count values, excluding duplicates and specific values
  • eaemeric
Replies
2
Views
796
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
593
pat67
P
A
Formula for function/argument "exclude".
  • arvindraut18
Replies
0
Views
796
arvindraut18
A
R
Formula help
  • rjyoung00
Replies
0
Views
608
rjyoung00
R
C
Replace a fixed number with a variable via popup
  • Colin Hayes
Replies
3
Views
976
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
789
m.m.ahmed
M
T
SumByColor & #NAME?
  • Ty
Replies
7
Views
3K
Gord
G
J
Skipping weekends during a count
  • justaj
Replies
1
Views
582
justaj
J
T
How to get range names to Apply across multiple tabs
  • TrippKnightly
Replies
1
Views
724
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
685
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
786
Gord
G
E
Auto worksheet name?
  • Esradekan
Replies
1
Views
648
joeu2004
J
B
The effects of time on value
  • B~O~B
Replies
1
Views
536
joeu2004
J
R
GST
  • rhhince
Replies
3
Views
658
Rich/rerat
R
Back
Top