*42*

Occasionally you may want to find the top 10 values in a list in Excel. Fortunately this is easy to do using the LARGE() function, which uses the following syntax:

**LARGE(array, k)**

where:

**array:**The array of values.**k:**The k^{th}largest value to find in the array.

This tutorial shows an example of how to use this function in practice.

**Example: Find the Top 10 Values in Excel**

Suppose we have the following column of 20 values in Excel:

To find the 10 largest values in the list, we can create a new column titled **K** that lists numbers 1 through 10.

We can then create a column adjacent tot it titledÂ **Value** and use the following formula to calculate the kth largest value in the dataset:

=LARGE($A$2:$A$21,C3)

We can simply copy and paste this formula down to the remaining cells in the column to find the 10 largest values in the dataset:

This leaves us with a list of the 10 largest values in the dataset:

We can see that the largest value isÂ **143**, the second largest isÂ **123**, the third largest isÂ **87**, and so on.

Note that we can use this method on a column of any length in Excel.

**Additional Resources**

How to Calculate a Five Number Summary in Excel

How to Calculate the Interquartile Range (IQR) in Excel

How to Create a Frequency Distribution in Excel