View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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