Assuming the table data is in A1:C10 with Row1 as headers please use the
below formula. Col B is project numbers and ColC is hours

=INDEX(B2:B10,MATCH(MAX(C2:C10),C2:C10,0))
--
If this post helps click Yes
---------------
Jacob Skaria


"VM" wrote:

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!