LARGE() Function–Get the top 10 values from a list

Book2.xlsxI need to return the top 10 values from a list (say, sales dollars) and their corresponding names (say, sales person's name).

I am using this as a guide:
http://www.excel-user.com/2011/02/la...lues-from.html

However my data has instances of more than one person's Sales Dollars being exactly the same. In those cases the INDEX/MATCH function returns the first Sales Person's name twice. In those cases how can I get it to skip the already-returned Sales Person's name and return the next one with the same corresponding Sales Dollars?

Thank you,

Hi

Be sure that will be easier for us to help you, if you upload a sample workbook, to see your data.

Hi

So try this Array formula(Control+Shift+ Enter) Not just Enter, in B17 and copy down.

Please Login or Register  to view this content.

Hope that helpe you.

Change the semi-colons to comma, if you have to do this.

You are welcome!

I am glad that helped you.