SMALL works in the opposite way compared to the LARGE function. It allows us to obtain the nth smallest value in a given range. Instead of using MIN for finding the smallest value in a given range, we could use SMALL to obtain the first, second, third, nth smallest value in that range.
Some other related topics you might be interested to explore are SORT, LARGE, RANK, and FREQUENCY.
This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Business Analyst, Consultant, Corporate Executive, or everyone preparing a corporate presentation.
You can now download the Excel template for free.