Hi --
I have a file where clients are ranked based on revenue figures.
In another table/range I'd like to pull in the top 10 clients.
I've tried doing this by having numbers 1-10 listed in the second table and using index/match to pull the client with the corresponding rank.
However, if two clients have the same revenue amount, then they'd both be ranked w/ a '5', for instance, and the next client in the order would be tagged w/ '7'.
Therefore, using my method, in the seond table only one client is pulled on the '5' line and the '6' line is left blank.
Is there a workaround?
(I'm also realizing that if the highest rank has multiple clients w/ that ranking then it would cause an issue, so maybe the list could pull all of those as well. So if 1-9 are unique, but there are three ranked at '10' then the secondary table shoul pull 12 clients in total)
I hope this is clear enough
Thank you for your help!
Bookmarks