Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

PERCENTRANK.EXC takes 2 required arguments and 1 optional argument:

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

#1)
The arguments for the PERCENTRANK.EXC function are:
Argument Required? Description
array Required The array or range of data with numeric values that defines relative standing.
x Required The value for which you want to know the rank.
significance Optional A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).
comments powered by Disqus