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

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

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top