Excel Function : PERCENTRANK

Download now!

Excel Function : PERCENTRANK

Category

Compatibility

Description

Returns the percentage rank of a value in a data set

Microsoft Excel Reference Page

https://support.office.com/en-us/article/PERCENTRANK-function-f1b5836c-9619-4847-9fc9-080ec9024442

Syntax and Description of the PERCENTRANK Excel Function

PERCENTRANK(array, x, [significance])

About PERCENTRANK Excel Function

The PERCENTRANK function in Microsoft Excel calculates the rank of a value in a data set as a percentage of the data set. This function can be used to compare the relative rank of a value in a data set.