# PERCENTRANKEXC

The **PERCENTRANKEXC** function returns the percentage rank of a value within a dataset using the exclusive method. It indicates the relative position of a value compared to other values and excludes the minimum and maximum values in the calculation.

### Syntax

```javascript
PERCENTRANKEXC(array, x, [significance])
```

### Arguments

The **PERCENTRANKEXC** function syntax has the following arguments:

* array: The range or list of numeric values. Required.
* x: The value for which you want to calculate the percentage rank. Required.
* significance: The number of significant digits for the result. Optional.

{% hint style="success" %}
The result ranges from greater than 0 and less than 1 (exclusive). It does not return 0 or 1 because the minimum and maximum values are excluded from the calculation.
{% endhint %}

### Example

<pre class="language-javascript"><code class="lang-javascript"><strong>PERCENTRANKEXC(10,20,30,40,50, 30)
</strong>// Returns 0.5
<strong>PERCENTRANKEXC(10,20,30,40,50, 20)
</strong>// Returns 0.25
<strong>PERCENTRANKEXC(10,20,30,40,50, 40)
</strong>// Returns 0.75
</code></pre>

You can use the **PERCENTRANKEXC** function to determine the relative standing of a value within a dataset when excluding the minimum and maximum values, especially when working with sample data.

{% hint style="warning" %}

* If the value being ranked is less than the minimum in the specified array, the **PERCENTRANKEXC** function returns 0.
* If the value being ranked is greater than the maximum in the specified array, the function returns an **#ERR** error.
  {% endhint %}

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FyT3OufZDps8og0DTp0FE%2F2026-02-17_16h29_51.png?alt=media&#x26;token=822ed96c-d183-4075-bbe5-a52e99f858ce" alt=""><figcaption><p>PERCENTRANKEXC function</p></figcaption></figure>

{% hint style="info" %}
We used the [**SELECT**](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue)
{% endhint %}

### Excel Equivalent

[PERCENTRANKEXC](https://support.microsoft.com/en-us/office/percentrank-exc-function-d8afee96-b7e2-4a2f-8c01-8fcdedaa6314)

### FAQs

**Q1. How is PERCENTRANKEXC calculated?**

PERCENTRANKEXC is calculated by determining the relative position of a value within a sorted dataset using the exclusive method, which excludes the minimum and maximum values in the calculation.

<p align="center"><strong>PERCENTRANKEXC = r / (n+1)​</strong></p>

Where:

* r = rank position of the value in the sorted dataset
* n = number of values in the dataset

If the value does not exactly match an existing value, the result is obtained by interpolating between the surrounding values.

It returns a value between 0 and 1 (exclusive) representing the relative standing of the value in the dataset.