setting a range automatically
 

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

setting a range automatically
 

You could Highlight the entire A column and enter a name into the Name box
Like MyRange then change your formula to this
=AVERAGE(MyRange)

"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

setting a range automatically
 

Hi Mike

Could you advise if I was to do this in a Macro what would the command be ?

Thanks

Brian

"Mike" wrote:

You could Highlight the entire A column and enter a name into the Name box
Like MyRange then change your formula to this
=AVERAGE(MyRange)

"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

setting a range automatically
 

Hi

should have added that i may want the range to start at A5 and omit the
first 4 rows

Cheers

brian

"Mike" wrote:

You could Highlight the entire A column and enter a name into the Name box
Like MyRange then change your formula to this
=AVERAGE(MyRange)

"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

setting a range automatically
 

=AVERAGE(A5:A65500)

"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

setting a range automatically
 

You might want to consider using a Dynamic Range Name, which automatically
expands and contracts to accomodate the data (and without VBA code).

See Debra Dalgleish's website for instructions;
http://www.contextures.com/xlNames01.html#Dynamic

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian