Breaking ties with rank alphabetically

In B4 enter formula:

=INDEX(Points!$A$4:$A$90,SMALL(IF(Points!$B$4:$B$90=C4,ROW(Points!$B$4:$B$90)-ROW(Points!$B$4)+1),COUNTIF(C$4:C4,C4)))

hold the CTRL and SHIFT keys down and press ENTER. Then copy down.

Similar for the other sections, just changing the respective ranges.

Well, the SMALL() here replaces the MATCH() to find the position number to INDEX() against...

SMALL(IF(Points!$B$4:$B$90=C4,ROW(Points!$B$4:$B$90)-ROW(Points!$B$4)+1),COUNTIF(C$4:C4,C4))

So we check if any of Points!B4:B90 matches value in C4, and if so we return the Row number for the position(s). This part ROW(Points!$B$4:$B$90)-ROW(Points!$B$4)+1 simply re-aligns the row count from 4:90 to 1:86 so that INDEX can use an actual position number starting from the natural 1.

This part: COUNTIF(C$4:C4,C4) is the k factor for the SMALL. As you copy the formula down, it counts duplicates and uses that to determine the next smallest row number to extract from, which aligns to next match to C4....

All you have to do in is change the Points!$B$4:$B$90 part to reference column of interest to find matches to... and change the C4's to match the first LARGE() result cell of the block.

Then you have to confirm the formula with CTRL+SHIFT+ENTER since it is an ARRAY formula... and copy down.