Home Â» Excel: How to Find the Top 10 Values in a List

# Excel: How to Find the Top 10 Values in a List

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