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