Can you please clarify what do you have in the second table? Or you mean that you need to create a report in a new sheet with sales by salesperson?

A simple pivot tale with a Value filter applied should be what you need, you can see a tutorial here: filter-excel-pivot-tables-by-values

Instead of Top 10, you can adjust the filter to show only top 3, or top 1, if you want just the highest values.

I think maybe our new member (who's name I can't read, sorry) has to make a kind of report where for every salesperson his/her maximum is visable. Can you confirm that? Then we can help you with the (not so difficult) solution!

Thank you for your desire to help and give a solution,
Showing pivot given me the maximum
and I want to know all the data of this figure.
See table of all sales agents and any other agent in a series of shows all its data.
(As the attachment - sheet)

I can not attach a file it writes that
104 Error - You do not have permission to upload files

Try uploading the file to our Help Desk instead, until the forum will be fully functional: Help Desk