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...
Bookmarks