| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum value from a pivot table - formula
I have a table as shown in the example below. Can you help me with a
formula that pulls out the the project code with maximum hours for an employee? This table is from a pivot, Employee ID Project Number Hours 78904 2057677 140 100 IU 8 530 IU 12 78904 Total 160 87659 2064777 120 2072147 40 87659Total 160 The result should show me like: Employee ID Project Number Hours 78904 2057677 140 87659 2064777 120 CAn anyone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of rows in pivot table data | Excel Discussion (Misc queries) | |||
| Pivot Table formula | Excel Discussion (Misc queries) | |||
| Maximum Size Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Formula | Excel Discussion (Misc queries) | |||
| maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
