| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter/sort data to give highest value from each day
Hi everyone,
I have 144 values for each day (readings taken every 10 minutes) and I want to graph only the highest readings from each because I have almost 50000 readings and that's ridiculous on a chart! Is there some way I can sort the data to give this information, or is there a formula/function I can use to get Excel to do this search for me and return only the highest value for each day? Thanks in advance Cootha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
