View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Max value for each day, and hour of that occurrence

Have data arranged in 3 columns, Date, Hour, Value. X days worth at a time.

Need to get the Max(Value) for each Date, and the Hour of that occurrence.
So the results would look something like the following in date, hour, value
format...

11/21/07 04:00 1235
11/22/07 02:00 1324
11/23/07 01:00 1256
..
..
..
simple problem, but so far the solution doesn't seem so..might it be?

Regards.