Finding the largest and smallest values with LARGE and SMALL

If you need to extract the largest value from a list, or the smallest value of a …list, both of those are fairly straightforward using the two functions, …Max and Min. And to make it even simpler, we can use, …either from the formulas tab, the drop arrow associated with auto sum, or on the …home tab, just click the drop arrow, and if you want to get the maximum value. …Simply choose Max and in the example here, if we're looking for salaries, …we'll simply redirect this by clicking Column F to come up with the highest salary.…

And similarly with lowest, same general idea, use the drop arrow, there's Min, …and then we can click Column F and find the minimum salary in this list. …Fairly straightforward in both cases. But sometimes you need to know the second …highest salary. Certainly one way to get there would be …to sort the data, but there is a function called large. …Large simply says, I'm looking at some data. …For example, in column F, and I want to know the second-highest entry, or the …