Skip to main content

PERCENTRANK.EXC

Definition of PERCENTRANK.EXC

Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.

Sample Usage

PERCENTRANK.EXC(A1:A100, A2, 4)

PERCENTRANK.EXC(A1:A100, 10)

Syntax

PERCENTRANK.EXC(data, value, [significant_digits])

  • data - The array or range containing the dataset to consider.
  • value - The value whose percentage rank will be determined.
  • significant_digits - [ OPTIONAL - 1 by default ] - The number of significant figures to use in the calculation.

Notes

  • If the value does not fall within the data given for the function, an estimation will be made to bring up a percentage rank for that value.

See Also

PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTRANK.INC: Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.

PERCENTILE: Returns the value at a given percentile of a dataset.

LARGE: Returns the nth largest element from a data set, where n is user-defined.

MIN: Returns the minimum value in a numeric dataset.

MAX: Returns the maximum value in a numeric dataset.

MEDIAN: Returns the median value in a numeric dataset.

In order to use the PERCENTRANK.EXC formula, start with your edited Excellentable

Then type in the PERCENTRANK.EXC Formula in area you would like to display the outcome:

Type in the complete PERCENTRANK.EXC formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

Error.

User does not have sufficient privileges to access this Content
Learn More


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.