Large Function listing top 10 salesmen
Posted: Fri Nov 30, 2018 5:40 am
Helo,
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:
Sales Person Sales
John Smith 2,000,000
Kevin Jones 1,970,000
Shirley Watts 1,500,500
Billy Barns 979,500
Bob Friendly 525,000
Bob Friendly 525,000 The second Bob Friendly should be Harold Pierce.
What can I do to fix this issue. Thanks for whatever help you can give me. DWoodly
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:
Sales Person Sales
John Smith 2,000,000
Kevin Jones 1,970,000
Shirley Watts 1,500,500
Billy Barns 979,500
Bob Friendly 525,000
Bob Friendly 525,000 The second Bob Friendly should be Harold Pierce.
What can I do to fix this issue. Thanks for whatever help you can give me. DWoodly