Use the LARGE and SMALL functions to find the nth largest or smallest number

Use the LARGE and SMALL functions to find the nth largest or smallest number

Syntax: LARGE(array, k), SMALL(array, k)

Step 1: Define the array of numbers and the value of k (e.g., 1 for the largest/smallest number, 2 for the second largest/smallest number, etc.).

Step 2: Enter the appropriate formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com