That's on the right track but I want to be able to choose one name and compare it to scores within a certain rank.
For example I would like:
Filter on A, all of A's results to be shown in black
Filter on top 3, all top 3 results shown in blue
If A has any top 3 results, to be shown in red
In the workbook you sent, removing a name from the list removes all their results from the visual (even those that fit in the rank filter).