# How to Find the Top 10% of Values in an Excel Column

To find the top 10% of values in an Excel column, follow these steps:

- Open your Excel workbook and identify the column that contains the values you want to analyze.
- Click on an empty cell where you want the top 10% value to be displayed. In this example, let's assume it's cell B1.
- In cell B1, type the following formula:

`=PERCENTILE.INC(range, 0.9)`

Replace "range" with the actual range of cells containing the values. For example, if your data is in column A and has 100 rows, your range will be A1:A100.

- Press Enter to get the result. The value in cell B1 will now show the top 10% value in the column.

## Example

Let's assume we have the following values in column A:

```
50
60
70
80
90
100
110
120
130
140
```

To find the top 10% value:

- Click on cell B1.
- Type the formula:

`=PERCENTILE.INC(A1:A10, 0.9)`

- Press Enter.

The result in cell B1 will be 126, which is the top 10% value in the given range.

Did you find this useful?