View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
akoskelo akoskelo is offline
external usenet poster
 
Posts: 1
Default How to average every 48 rows of data for 20,000 rows?

Hi. I have a huge spreadsheet (~20,000 rows). I need to average every 48 rows
into one value. Is there a quick and easy way to do this without scrolling
through all 20,000 rows and copy-pasting the "average" function every 48th
row?

Thank you.