View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default 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...