PERCENTRANK.EXC(array, x, [significance]) - Returns rank of x in array as a percentage in (0,1) (excludes endpoints). - If x is outside [min(array), max(array)] -> #N/A - Rounds to ‘significance’ decimal places (default 3).
Table of Contents