Listing of different names with same rankings

[mujeebpc]

I have a set of stundents list with their ranking.
Some stundents have same ranking.
How can get the lis of different students names with same rankings?

 

[BSALV]

add a small number to column A for example row()/10000 and then your rankings aren't the same anymore.

 

[mujeebpc]

add a small number to column A for example row()/10000 and then your rankings aren't the same anymore.

Values in Column A is getting through a formula, then how I can add value there ?

 

[BSALV]

add in that same formula your row divided by 10000

=myformula+row()/10000

 

[Fluff]

How about

=INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=D2,ROW($B$2:$B$10)-ROW($B$2)+1),COUNTIF(D$2:D2,D2)))

This needs to be confirmed with Ctrl Shift Enter.

 

[mujeebpc]

How about

=INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=D2,ROW($B$2:$B$10)-ROW($B$2)+1),COUNTIF(D$2:D2,D2)))

This needs to be confirmed with Ctrl Shift Enter.

Working! ?
Thank you ?

 

[Fluff]

Glad we could help & thanks for the feedback.