A | B | C | |
1 | Name | Points | Current Leader |
2 | Amy | 10 | Amy |
3 | Bob | 5 | Amy |
4 | Amy | 2 | Amy |
5 | Caleb | 15 | Caleb |
6 | Bob | 10 | Caleb |
7 | Bob | 1 | Bob |
8 | Amy | 4 | Bob |
9 | Bob | 1 | Bob |
10 | Amy | 2 | Amy |
<tbody>
</tbody>
I'm trying to find a formula for column C, which outputs the person with the greatest accumulated score (accumulates moving down. E.g. C5 outputs the person with the highest score between rows 1 and 5). Notes:
- If there is a tie (e.g. C6, C8), column C returns the incumbent name (the name higher on the list) OR can display "Tie"
- I'd rather not use helper columns FOR NAMES if possible, as I have many names. But helper columns would be OK, just not for names.
Thanks!