Small and Large - Excel Functions | MS Excel Tutorials for Beginners | MS Excel | Analytics Leap
Small and Large - Excel Functions
visit us at www.a-leap.com
Learn MS Excel (CPD UK Accredited Course) - https://www.a-leap.com/course?coursei...
The SMALL function is useful when you want to retrieve the nth lowest value from a set of data — for example, the first, second, or third fastest times in a race.
Like LARGE, the SMALL function retrieves numeric values based on their position in a list when sorted by value.
The LARGE function is useful when you want to retrieve the nth highest value from a set of data — for example, the first, second, or third highest scores for a test. Like the SMALL function, the LARGE function retrieves numeric values based on their position in a list when sorted by value.