# How to Use Excel PERCENTRANK.EXC Function?

PERCENTRANK.EXC Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to get the relative rank of a value in a data set, you can use the PERCENTRANK.EXC function.

In this post, we will explore how to use the Excel PERCENTRANK.EXC Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of PERCENTRANK.EXC Function

• This function returns the rank of a value in a data set as a percentage of the data set exclusive of first and last values.
• It can be used to evaluate the relative standing of a value within a data set.
• The below image has shown the function behavior of the related functions.

## Syntax

• Here, you will see the syntax of the PERCENTRANK.EXC function.
• To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
• Once you enter the formula, click the button to get the result.

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

Arguments Explanation:

• Array – It is the input array or range of data.
• x – The input value for which you want to know the rank.
• Significance – It is an optional one. This argument represents the number of significant digits for the returned percentage value. If it is omitted, it will take three digits by default (For example, 0.294).

Note:
1) If the significance is less than 1 and then this function returns #NUM! Error.
2) If the array is empty, it will return #NUM! Error.
3) If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

## Examples

• Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
• In this screenshot, you can be able to see the input range in Column A, and we will get the relative rank of a value in a data set using the PERCENTRANK.EXC function.
• Then, you must enter the formula in the cell below to get the result.
• After entering the formula, you need to click the  button to get the output.
• Once you get the output for the first cell, you have to drag down that cell to fill in the remaining values as shown in the below image.
• If the significance is less than 1 and then this function returns #NUM! Error.
• If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

From the above examples, you can clearly understand how to use PERCENTRANK.EXC Function.

## Closure

In this post, you can learn the usage of Excel PERCENTRANK.EXC Function with its syntax, explanation, and examples. Share your feedback in the comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.

## Video Tutorial

The following video will show you how to apply the PERCENTRANK.EXC function in the spreadsheet.