Microsoft Excel Functions & Formulas

Use the INDEX, MATCH, and LARGE functions to

determine and locate the best salesperson

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 oth-

ers 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.

4

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.