How To Use PERCENTRANK.EXC() Function in Google Sheets


Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

Common questions about the PERCENTRANK.EXC formula:
- How can it be used to rank a data set?
- How can it calculate the percentage of a value relative to the other values in a data set?
- What is the syntax of the formula?

How can the PERCENTRANK.EXC formula be used appropriately?
- The PERCENTRANK.EXC formula can be used to find a value's position within a given data set. It is useful for ranking values within a data set and visualizing its percentile.

How can the PERCENTRANK.EXC formula be commonly mistyped?
- Common typos when entering the PERCENTRANK.EXC formula include misspelling the PERCENTRANK.EXC portion, using the incorrect argument syntax, or forgetting parenthesis, commas, or quotation marks.

What are some common ways the PERCENTRANK.EXC formula is used inappropriately?
- The PERCENTRANK.EXC formula should not be used as a substitute for sorting the data or determining the percentile manually.

What are some common pitfalls when using the PERCENTRANK.EXC formula?
- Common pitfalls would include forgetting to specify alternate parameters when using the PERCENTRANK.EXC formula, such as tie values and the construction of the reference array.

What are common mistakes when using the PERCENTRANK.EXC Formula?
- Common mistakes when using the PERCENTRANK.EXC formula include mistyping the formula syntax, forgetting to specify the array argument correctly, and failing to account for tied values.

What are common misconceptions people might have with the PERCENTRANK.EXC Formula?
- Common misconceptions people might have include thinking that the PERCENTRANK.EXC formula ranks with respect to the entire data set, when in fact it uses only the data in its given array.

How To Actually Use PERCENTRANK.EXC() in Sheets

PERCENTRANK.EXC(data, value, [significant_digits])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Generate a PERCENTRANK.EXC() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.