Non-Macro way to do this??

9

99atlantic

say cell M4 contains the value 15

now in another cell say you've got the formula stdev(b4 :
b?????M4????)

basically what i want it to do is see the b????M4???? as
cell B, row (whatever value M4 contains)

So if M4 contains 20, the formula would be stdev(b4:b20)

If M4 contains 45, formula would be stdev(b4:b45)
etc....

i've tried everythingi could think of (e.g., stdev
(b4:b$m4), but nothing works

i know you can do it w/ a macro, but does anybody know how
to do it w/o a macro?
 
M

Myrna Larson

There are at least 2 ways to do this:

=STDEV(INDIRECT("B4:B" & M4))

=STDEV(OFFSET(B4,0,0,M4-3,1))
 
Top