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:

1. Open your Excel workbook and identify the column that contains the values you want to analyze.
2. 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.
3. 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.

4. 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:

1. Click on cell B1.
2. Type the formula:

=PERCENTILE.INC(A1:A10, 0.9)

3. Press Enter.

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