Thread: Dynamic average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike D. Mike D. is offline
external usenet poster
 
Posts: 36
Default Dynamic average

I am looking for a way to average a series of number in a column. I would
like this formula to average the numbers up to a quantity of 20. So, if
there are 3 numbers in the column, I would like it to average those 3. If
there are 23, I would like it average the last 20. Thanks, Mike.