Function on dynamicly adding rows in column
 

Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that start at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))

Function on dynamicly adding rows in column
 

woops, that sent before I had a chance to finish....

So, I've tried =STDEV(CO12:INDEX(CO:CO,ROW()-1)) but that will want to
calculate the whole column. I need it to be from CO12:"infinity"

also, because of how the worksheet is built, I can't easily move this
formula out of the CO column.

Thanks!

"John" wrote:

Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that start at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))

Function on dynamicly adding rows in column
 

Not sure what you're looking for but why not just do this:

=STDEV(CO12:CO65536)

Empty cells are ignored but you need at least 2 numbers in the range to
calculate otherwise you get an error.

Or, if you really do want a dynamic range assuming there will be no empty
cells *within* the range and the range contains only numbers:

=STDEV(CO12:INDEX(CO12:CO65536,COUNT(CO12:CO65536) ))


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that start
at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))

Function on dynamicly adding rows in column
 

Hi T, thanks. Is there any way to get around the "no empty cells in the
range" issue?

Also, isn't your formula limited to 65,536 rows??


"T. Valko" wrote:

Not sure what you're looking for but why not just do this:

=STDEV(CO12:CO65536)

Empty cells are ignored but you need at least 2 numbers in the range to
calculate otherwise you get an error.

Or, if you really do want a dynamic range assuming there will be no empty
cells *within* the range and the range contains only numbers:

=STDEV(CO12:INDEX(CO12:CO65536,COUNT(CO12:CO65536) ))


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that start
at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))

Function on dynamicly adding rows in column
 

I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)


"John" wrote:

Hi T, thanks. Is there any way to get around the "no empty cells in the
range" issue?

Also, isn't your formula limited to 65,536 rows??


"T. Valko" wrote:

Not sure what you're looking for but why not just do this:

=STDEV(CO12:CO65536)

Empty cells are ignored but you need at least 2 numbers in the range to
calculate otherwise you get an error.

Or, if you really do want a dynamic range assuming there will be no empty
cells *within* the range and the range contains only numbers:

=STDEV(CO12:INDEX(CO12:CO65536,COUNT(CO12:CO65536) ))


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that start
at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))

Function on dynamicly adding rows in column
 

I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)

And seeing your formula I think I figured out what you meant by dynamically
adding rows. You're inserting rows and you want the formula to always start
from CO12.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
I think I figured it out...:
=STDEV(INDIRECT("$CO$12"):$CO$92)


"John" wrote:

Hi T, thanks. Is there any way to get around the "no empty cells in the
range" issue?

Also, isn't your formula limited to 65,536 rows??


"T. Valko" wrote:

Not sure what you're looking for but why not just do this:

=STDEV(CO12:CO65536)

Empty cells are ignored but you need at least 2 numbers in the range to
calculate otherwise you get an error.

Or, if you really do want a dynamic range assuming there will be no
empty
cells *within* the range and the range contains only numbers:

=STDEV(CO12:INDEX(CO12:CO65536,COUNT(CO12:CO65536) ))


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi everyone, I hope some can help me with this:

I need to run a standard deviation on a range within a column that
start
at
CO12 and goes on to dynamically added rows

So far I've tried:

=STDEV(CO12:INDEX(CO:CO,ROW()-1))