need to jump cells in column data when finding average, max and mi

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

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