Fresh Excel Tips

To determine the highest value in a list, we used the MAX function. To find out multiple high values of a range, the LARGE function can be used. This function returns the nth highest value in a set of data.

LARGE(array, n)
array: Array or range of numerical data in which we want to find the nth highest value.
n: The position from the highest in the array or range of data to return.

To determine the three highest values of a range:

1. In cells A2:C10 type any values from 0 to 99.
2. Number cells A12, A13, and A14 with 1, 2, and 3.
3. Select cells B12:D14 and type the following formula: =LARGE(B$2:B$10,$A12).
4. Press Ctrl+Enter.

1. Use the SMALL function to find the smallest values in Excel
2. Use the INDEX, MATCH, and LARGE functions to determine the best salesperson
3. How to calculate the average output using the AVERAGE function
4. Use the RANDBETWEEN function to generate random values in a specified range
5. How to Use the QUARTILE function to calculate the quartiles