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.
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.