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