Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson - Basic Statistical Function - Microsoft Excel Tutorials

Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson using Microsoft Excel

As seen in the previous tips, it is easy to find out the highest value in a list. But how do you find the one person on a sales team who sold the most? And how do you find out how much ahead of the others he or she is?  Start with the LARGE function to determine the highest sale. Then use the INDEX and MATCH functions to retrieve the name of the employee.

To determine and locate the best employee:

1. In cells B2:B10 type the daily sales of the employees.
2. Select cell D3 and type the following formula: =INDEX($A$2:$A$10,MATCH(LARGE($B$2:$B$10,1),$B$2:$B$10,0)).
3. Press <-Enter->.
4. Select cell D6 and type the following formula: =LARGE($B$2:$B$10,1)-LARGE($B$2:$B$10,2).
5. Press <-Enter->.

Use the INDEX MATCH and LARGE functions to determine and locate the best salesperson