If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|