formula to get the name of the next player with the same score

in K25

=INDEX('Player Score'!C6:C113,SMALL(IF('Player Score'!$DY$6:$DY$113=L25,ROW('Player Score'!$DY$6:$DY$113)-ROW('Player Score'!DY6)+1),COUNTIF($L$25:$L25,$L25)))

Hi aydaria,

Try using below formula:-

Formula:

{=INDEX('Player Score'!$C$5:$C$114,SMALL(IF('Player Score'!$DY$5:$DY$114='Game Record'!$L27,ROW('Player Score'!$DY$5:$DY$114)-4,""),ROW($A1)),1)}

See attached- ScoreboardDummy.xlsx

regards,
DILIPandey

<click on below 'star' if this helps>

First, you should use $ sign around cells.
Must be hard write formula your way....

Formula:

=LARGE(('Player Score'!$B$6:$B$113='Player Score'!D118)*'Player Score'!$DY$6:$DY$113,1)

Second in array use IF instead of * (in this case).
Otherwise errors will appear.

Formula:

=LARGE(IF('Player Score'!$B$6:$B$113='Player Score'!$D$118,'Player Score'!$DY$6:$DY$113),ROW(A1))

(I've also changed 1 to ROW(A1)

Here, I've also adopted your formula...
Please note that you'll have now results 141,03...
But change it to show 0 decimals and you will again see 141...

Hi aydaria,

Hi Dilipandey,
My final intention is to have a single formula from K25-K29, but it's not getting the correct values for K25, what can I change there?

Try using below formula:-

{=INDEX('Player Score'!$C$5:$C$114,SMALL(IF('Player Score'!$DY$5:$DY$114='Game Record'!$L22,ROW('Player Score'!$DY$5:$DY$114)-4,""),COUNTIF(L22:L$29,L22)),1)}

See attached:- ScoreboardDummy.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome aydaria.. Cheers

regards,
DILIPandey

<click on below 'star' if this helps>