Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average every 20 rows
If you want Group numbers instead of alternating A, B - you can put the
following in column A and copy down the column. ="Group "& INT((ROW()+18)/20) 18 was determined by 20 minus the row number of the first row that actually contained the data. My data started in row 2 so 20-2=18, adjust as needed. Then select Column A copy, then click Edit/Paste Special/values to hardcode the group numbers. Then use Subtotal. "Karen K" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |