getting duplicated values depending on rank order

[zbor]

Here I make example with small function but doesn't need to be it.

So, I have some names and values.
Rank function give me order for those values.

Small function gives me ascending order.

I want to get first n (let say 5) values back next to each other but can't use VLOOKUP function because sometimes I get duplicates (red numbers).

If there is more same numbersthat small function returns... It need to give me all of them, no matter 5 is limit...

So I guess, only question is how to get back values of rank function that are duplicated.

Book1.xls

Edit: Values changes every day so can't use filter and just sort them...

[DonkeyOte]

If you can add a helper...

D2: =$C2+(COUNTIF($C$2:$C2,$C2)/1000000)
copy down

F2: =INDEX(A:A,MATCH(E2+(COUNTIF($E$2:$E2,$E2)/1000000),$D:$D,0))
copy down

this approach avoids need for Arrays.

[zbor]

Yup, that worked
let me test it further