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