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.
|