ExcelBanter - Formula to get the maximum hours

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to get the maximum hours (https://www.excelbanter.com/excel-discussion-misc-queries/229091-formula-get-maximum-hours.html)

Formula to get the maximum hours

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

Formula to get the maximum hours

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