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