View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen K
 
Posts: n/a
Default Average every 20 rows

I have a data of 14000 rows. I need Average on every 20 cells. Instead of
copying and pasting the formula into every 20 cells to get the result which
will take forever is there a function to obtain the results automatically?

I'm trying group every 20 rows automatically unfortunately it didn't help
either. Help!