Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to jump cells in column data when finding average, max and mi
I have a continuous column of data and there is data in every cell, but I
want to find the average, max or min for every 96th block of data. For example, I have readings every 15 minutes for an entire day, but I want to find the max, min and avg. for each day without having to retype the max, min formula every time. I want to put the data in another column so I can make graphs... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to jump cells in column data when finding average, max andmi
Suppose your data is in column A, beginning in A1, then you could have
this for your minimum in, say, C1: =MIN(INDIRECT("A"&(ROW(A1)-1)*96+1&":A"&ROW(A1)*96)) and this for the maximum in D1: =MAX(INDIRECT("A"&(ROW(A1)-1)*96+1&":A"&ROW(A1)*96)) and this in E1 for the average: =AVERAGE(INDIRECT("A"&(ROW(A1)-1)*96+1&":A"&ROW(A1)*96)) Then as you copy these down they will each look at the next block of 96 rows in turn. Hope this helps. Pete On Nov 17, 6:00*am, Andrew wrote: I have a continuous column of data and there is data in every cell, but I want to find the average, max or min for every 96th block of data. *For example, I have readings every 15 minutes for an entire day, but I want to find the max, min and avg. for each day without having to retype the max, min formula every time. *I want to put the data in another column so I can make graphs... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to average subtotal cells in a column with other data | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
Average of cells in a column | Excel Worksheet Functions | |||
problem in finding words into cells of a column | Excel Discussion (Misc queries) | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |