If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so on, or what if you want to find the second smallest and so on. Well for that you have the LARGE and SMALL function.

This can be very useful if you want to find out who came second or third, aside of course finding out who came first. You could use MAX for finding out who came first but you could also using LARGE too.

Here in this video I show you how to use both of these and a quick reminder of how MAX and MIN work.