I am brand new to this forum and tried to search for my answer, but only found out stuff that I am already familiar with. Here's my problem. I can list the top 10 sales values without the salesperson's names, but I also need the names for the 10 best salespeople. The problem I have is that two of the sales people have sold the exact same amount, but my formula only lists the first salesperson name twice. I used Vlookup and tried using the large function, but got the same results. For some reason it will only list the name of the first salesperson Example below:

Have you considered using a filter instead of a function? To do that, select the data, including the header row and then the menu item Data -> Filter -> AutoFilter. From the drop down menu on the header of the Sales column select Top 10. You can then copy the list to a convenient place. Alternatively, you can use Data -> Filter -> Standard Filter, set Field Name to Sales, Condition to Largest, Value to 10 and under More Options choose to Copy Results to a convenient place.

Windows 10 and Linux Mint, since 2017If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.

Try to combine the LARGE() and the VLOOKUP() functions. The names must be located at the right side of the values for the function VLOOKUP(): Make a helper column with a copy of the names.

Or please upload your ODF type samlpe file here.

Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6 Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

This way you get erroneous results as soon as the data LARGE() is applied to, contain any duplicates. Disambiguating them "on the fly" is possible, but a bit tricky. I would suggest to use a sorted copy (option 'Copy sort results to:').

This way you get erroneous results as soon as the data LARGE() is applied to, contain any duplicates.

Yes, it is true.

Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6 Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.