View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
swalk88 swalk88 is offline
external usenet poster
 
Posts: 6
Default Finding the Max, Min values based on certain criteria for an a

Hi again,

Thanks for that, that part is working now, just have a few more questions.
There is also a volume for a certain time, would I just use a Sumif formula
to find the volume at the time?

Also, if I want to group the numbers in 5 minute intevals. i.e. 10:00-10:05
how would I go about that?

Lastly, How do I plot it on a chart and get it to ignore that 0's that may
appear in the data.

Thank you so much for the help.