View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VM VM is offline
external usenet poster
 
Posts: 6
Default 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