Maximum value from a pivot table - formula
On Apr 28, 12:02*pm, Jacob Skaria
wrote:
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!- Hide quoted text -
- Show quoted text -
Thanks Jacob. I tried the formula, but it shows me the value of 0..I'm
not sure if I'm doing something wrong?
|