In this video, you will learn how to find the highest, lowest, second highest, and third lowest values in a range using the MIN, MAX, SMALL and LARGE functions in Excel.
The MIN and MAX functions will help you determine the lowest and highest values respectively, while the SMALL and LARGE functions can be used to find the nth smallest and nth largest values in a range.
I will explain how to use each of these functions step-by-step, with examples that you can follow along with. By the end of this video, you will have a solid understanding of how to use these functions to analyze your data in Excel.