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

If the Employee IDs are in column A
Project in B
Hours in C

=INDEX(A2:A6,MATCH(MAX(C2:C6),C2:C6))

Will find the employee number who has the max hours

=INDEX(B2:B6,MATCH(MAX(C2:C6),C2:C6))

Will find the project with the maximum hours

edvwvw

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

--
Message posted via http://www.officekb.com