How to Find the Top 10% of Values in Google Sheets


The following step-by-step example shows how to highlight the top 10% of values in a column in Google Sheets.

Step 1: Enter the Data

First, let’s enter the following dataset into Google Sheets:

Step 2: Highlight Top 10% of Values

Next, click the Format tab and then click Conditional formatting:

In the Conditional format rules panel that appears on the right side of the screen, type B2:B21 in the Apply to range box, then choose Custom formula is in the Format rules dropdown box, then type in the following formula:

=PERCENTRANK($B$2:$B$21,B2)>=90%

Once you click Done, the top 10% of values in the Points column will be highlighted:

If you would like to highlight the entire row that contains the top 10% of values in the Points column, type A2:B21 in the Apply to range box, then choose Custom formula is in the Format rules dropdown box, then type in the following formula:

=PERCENTRANK($B$2:$B$21,$B2)>=90%

Once you click Done, the entire row that contains the top 10% of values in the Points column will be highlighted:

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Calculate Standard Deviation in Google Sheets
How to Calculate Descriptive Statistics in Google Sheets
How to Calculate the Interquartile Range in Google Sheets

Leave a Reply

Your email address will not be published.