SMALL and LARGE function in Excel - How to find the Nth value
Learn More - other ways to find the nth value
http://theexcelclub.com/nth-largest-i...
Both MIN and MAX in Excel will return the Minimum or Maximum value from a list. But what if you want to return a value that is the Nth smallest or the Nth largest in Excel? How would you go about this type of Ranking?
In this video we will look at using Excel SMALL and LARGE functions to return the nth value from a list. Read more about using the OFFSET function to rank values
Would love to hear your feedback....comment below
Sign up to our newsletter
https://theexcelclub.newzenler.com/f/...
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist