Returning Names in Ranked order WITH Ties

Hello,

I am setting up a leader board for tournament to which I put in raw data to keep track of points per name.
I want to create a separate book that displays the leader board in order of rank and automatically adjusts the names in real time.
However my issue that in this game it is highly possible for players to get the same score.

I my leader board now is not showing players all players with ties (#N/A)
Also players with ties are skipping some ranks (i.e. ...3rd, 4th, ___, 6th etc.) with error "RANK has no valid input data"
Don't mind column N, O.

Book 1 (Score)
Capture1.PNG
Book 2 (Leaderboard)
Capture2.PNG

I have attempted to use the following formula(s)

=INDEX(name,MATCH(large(scorerank,RANK(A3,scorerank,0)),scorerank,0)))

=INDEX(points,MATCH(large(scorerank,RANK(A3,scorerank,0)),scorerank,0)))

and the Rank column is just INDEX MATCH for the of the scorerank according to the name.
Purple text indicate a named range.

I tried to understand how to use COUNTIF but could not get it correctly.

First time poster on this forum.
Any help would be greatly appreciated!

Edit: workbook attached

Edit: Sample workbook attached to original post as requested!

-------
I don't want to break the rules but it seems as though I cannot add a link because I only have a few posts...
Sorry to admins, I'm not sure if there is another way??

drive.google. com/file/d/1NvlE08BQ4XxVxycTqRRz0cCUcABe3P32/view?usp=sharing