Let's say I have a table that lists fruit in one column, and quantity in another:
<tbody>
</tbody>
I'm looking to build a third column that designates the line's rank by quantity per fruit. So apples are only ranked against other apples, pears against pears and so on. So far, if I use RANK(B1, B:B), I rank all quantities regardless of fruit type.
Presuming my table has many more lines than above, how can I designate the range in the RANK formula to say: all cells in column B that have the same value in column A?
In the above examples, the Rank column would list, in descending order: 2, 1, 1, 1.
Fruit | Quantity | Rank |
Apple | 3 | |
Orange | 5 | |
Pear | 2 | |
Apple | 6 |
<tbody>
</tbody>
I'm looking to build a third column that designates the line's rank by quantity per fruit. So apples are only ranked against other apples, pears against pears and so on. So far, if I use RANK(B1, B:B), I rank all quantities regardless of fruit type.
Presuming my table has many more lines than above, how can I designate the range in the RANK formula to say: all cells in column B that have the same value in column A?
In the above examples, the Rank column would list, in descending order: 2, 1, 1, 1.