Excel - Quickly Find Highest/Lowest/Nth Highest/Nth Lowest Value in a List
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.
🗒 Notes and Resources
Download a copy of the files used in this video: https://share.getcloudapp.com/yAuJLG4Q
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #highest #lowest