Dear lazyweb
How do I make Excel do value ranking among cells of a similarly typed value? For instance - I want a function which generates the values in the “Team Rank” column for the following sheet based on the score of people on a team:
| Person | Team | Score | Team Rank |
|---|---|---|---|
| Aaron | A | 1 | 1 |
| Bryce | A | 2 | 2 |
| Curtis | B | 1 | 1 |
| Dustin | B | 50 | 2 |
| Evan | B | 100 | 3 |
In other words, I want the ref in RANK(number, ref, [order]) to be a lookup over the range “Team” and only compare the current row’s Score against those other scores of people from the same Team.