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...

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...