Quick Navigation

PERCENTRANK.EXC Function

Excel 2010+

Summary

The PERCENTRANK.EXC function calculates the percentage rank of a specific value within a dataset, returning a value between 0 (exclusive) and 1 (exclusive). This exclusive ranking method provides precise percentile positioning ideal for statistical analysis and data distribution studies.

Syntax

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

Parameters

Parameter	Type	Required	Description
array	`Range/Array`	Yes	Data range containing numeric values for ranking analysis
x	`Number`	Yes	Value to find percentage rank within the dataset
significance	`Number`	No	Number of significant digits (default: 3) for result precision

Using the PERCENTRANK.EXC Function

PERCENTRANK.EXC excels in performance analytics, test scoring, sales rankings, and quality control where understanding a value's relative position within a distribution is essential. Unlike PERCENTRANK.INC, it excludes endpoints for more conservative ranking.

Common PERCENTRANK.EXC Examples

Basic Percentage Rank

=PERCENTRANK.EXC(A2:A10,7)

Returns 0.7 (70th percentile) for value 7 in dataset A2:A10.

Interpolated Ranking

=PERCENTRANK.EXC(A2:A10,5.43)

Returns 0.381 for value 5.43 through interpolation between dataset values.

Custom Precision

=PERCENTRANK.EXC(A2:A10,5.43,1)

Returns 0.3 (rounded to 1 significant digit) for cleaner display.

Frequently Asked Questions

PERCENTRANK.EXC excludes endpoints (returns 0..1 exclusive), providing more conservative rankings suitable for strict statistical analysis.

The function interpolates between surrounding values to provide accurate percentage positioning.

Yes, use the optional significance parameter (minimum 1) to specify desired precision.

Common Errors and Solutions

#NUM! error

Cause: Empty array or significance < 1

Solution: Ensure array contains data and significance ≥ 1

#VALUE! error

Cause: Non-numeric array values or x parameter

Solution: Verify all inputs contain valid numbers

Notes

Returns values strictly between 0 and 1 (never exactly 0 or 1)
Perfect lowest/highest values approach but never reach endpoints
Interpolation ensures smooth ranking for any input value
Available only in Excel 2010 and later versions

Compatibility

Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2007, Excel 2003, Earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+