| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert new rows based on Data in other rows | Excel Worksheet Functions | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Threaded Mode
