Fresh Excel Tips

As illustrated earlier, 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.

1. How to Use the LARGE function to find the highest values in Excel
2. Use the ISODD and COLUMN functions to determine odd columns
3. How to Use the SMALL function to compare prices in Excel
4. How to Use the STDEV function to determine the standard deviation
5. Use the MIN function to find the employee with the lowest sales