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