What is the syntax for PERCENTRANK.EXC in Excel?

The syntax for PERCENTRANK.EXC is: =PERCENTRANK.EXC(array, x, [significance])

How do I use the PERCENTRANK.EXC function?

To use PERCENTRANK.EXC, type =PERCENTRANK.EXC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does PERCENTRANK.EXC work with?

PERCENTRANK.EXC works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is PERCENTRANK.EXC not working in my Excel?

Common issues with PERCENTRANK.EXC include #N/A if x not in array range. Start by checking the syntax =PERCENTRANK.EXC(array, x, [significance]), then verify each referenced cell or range.

Statistical

PERCENTRANK.EXC Function in Excel

Returns the rank of a value in a data set as a percentage (0..1, exclusive).

Syntax

=PERCENTRANK.EXC(array, x, [significance])

Arguments

array (required): Data array
x (required): Value to rank
significance (optional): Decimal places (default 3)

Examples

=PERCENTRANK.EXC(A1:A100, 50) - Percentile rank (exclusive) - Result: Rank as decimal

PERCENTRANK.EXC for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#N/A if x not in array range

Use cases

Relative standing
Statistical analysis
Benchmarking

Frequently asked questions

What is the PERCENTRANK.EXC function in Excel? PERCENTRANK.EXC returns the rank of a value in a data set as a percentage (0..1, exclusive). The syntax is =PERCENTRANK.EXC(array, x, [significance]). Typical use cases include relative standing, statistical analysis, benchmarking.
How do I use the PERCENTRANK.EXC function? To use PERCENTRANK.EXC, type =PERCENTRANK.EXC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does PERCENTRANK.EXC work with? PERCENTRANK.EXC works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is PERCENTRANK.EXC not working in my Excel? Common issues with PERCENTRANK.EXC include #N/A if x not in array range. Start by checking the syntax =PERCENTRANK.EXC(array, x, [significance]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.