| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Max value for each day, and hour of that occurrence
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. -- HTH... Jim Thomlinson "Rich" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Max value for each day, and hour of that occurrence
Thanks Jim.
Didn't work on days, but it did on hour. "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "Rich" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
