Hello Friends,
I need a Rank formula based on criteria
Here is a sample data (having Names in A2:A8 & Qty in D2:D8)
NAMES Qty
<tbody>
</tbody>
Required names (rank wise) based on sum of Quantites in Column D
In this case answer should be
John (coz john has the maximum qty of 147)
Peter (then peter with a qty of 126)
Mike (then Mike with a qty of 61)
Any help would be appreciated.
Regards,
Humayun
I need a Rank formula based on criteria
Here is a sample data (having Names in A2:A8 & Qty in D2:D8)
NAMES Qty
Peter | 25 |
John | 99 |
Mike | 36 |
Mike | 25 |
John | 48 |
Peter | 99 |
Peter | 2 |
<tbody>
</tbody>
Required names (rank wise) based on sum of Quantites in Column D
In this case answer should be
John (coz john has the maximum qty of 147)
Peter (then peter with a qty of 126)
Mike (then Mike with a qty of 61)
Any help would be appreciated.
Regards,
Humayun
Last edited: