Max value for each day, and hour of that occurrence

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

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.
 
Easiest way is probably to use a pivot table. Place your cursor in the middle
of the source data and select Data|Pivot Table -> follow the wizard. Place
the Date and Time in the left hand columns and the Values in the middle. When
the table is created right click on the days and select Field
Settings|Advanced -> Top 1 Items by Value.
 
Back
Top