| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to average subtotal cells in a column with other data | Excel Discussion (Misc queries) | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| Average of cells in a column | Excel Worksheet Functions | |||
| problem in finding words into cells of a column | Excel Discussion (Misc queries) | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Threaded Mode
