Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet of data that will be increasing in number of rows and
number of columns, but within that data starting from cell "J1" I need to average together the data in every five rows then move over 5 columns and average together every five rows in that column. This needs to continue until the column is blank (except for the value in the header in row 1). Actually, if it helps the columns that I need to identify these averages will always have the title "Output" in header row. Any assistance with code would be greatly appreciated! Thanks, Holly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting averages from a column | Excel Discussion (Misc queries) | |||
macro averages number above and below | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Column Chart With Averages Displayed | Charts and Charting in Excel | |||
Macro that counts rows and averages data in row | Excel Programming |