Excel Function : PERCENTRANK.EXC
Category
Statistical
Description
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
Microsoft Excel Reference Page
Syntax and Description of the PERCENTRANK.EXC Excel Function
PERCENTRANK.EXC is an Excel function that returns the rank of a given value in a data set as a percentage of the data set.
About PERCENTRANK.EXC Excel Function
PERCENTRANK.EXC returns the rank of a value in a data set as a percentage of the data set. For example, if four values in a data set are 1, 2, 3, and 4, the PERCENTRANK.EXC function returns the following values: 0%, 25%, 50%, 75%.
