| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overtime for 8 hour and 40 hour | Excel Discussion (Misc queries) | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| V Lookup 2nd Occurrence | New Users to Excel | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Threaded Mode
