How to Use the SMALL function to compare prices in Excel
In the example, a worksheet lists offers from different suppliers. To make a decision as to which is the best offer, the SMALL function can be used to check for the lowest price. As in our previous tip, you can use the INDEX and MATCH functions to get the names of the companies.
To find out [...]
Use the INDEX, MATCH, and LARGE functions to determine the best salesperson
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 [...]
