Skip to main content

RANK

Definition of PROB

Returns the rank of a specified value in a dataset.

Sample Usage

RANK(A2,A2:A100)

RANK(4,A2:A100,1)

Syntax

RANK(value, data, [is_descending])

  • value - The value whose rank will be determined.

    • If data does not contain value in any cell or element, RANK will return the #N/A error.
  • data - The array or range containing the dataset to consider.

  • is_ascending - [ OPTIONAL - 0 by default ] Whether to consider the values in data in descending or ascending order.

    • If this is 0, the greatest value in data will have rank 1; if this is 1, the least value in data will have rank 1.

See Also

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

QUARTILE: Returns a value nearest to a specified quartile of a dataset.

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

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

MINA: Returns the minimum numeric value in a dataset.

MIN: Returns the minimum value in a numeric dataset.

MEDIAN: Returns the median value in a numeric dataset.

MAXA: Returns the maximum numeric value in a dataset.

MAX: Returns the maximum value in a numeric dataset.

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

AVERAGEA: Returns the numerical average value in a dataset.

AVERAGE: Returns the numerical average value in a dataset, ignoring text.

In order to use the RANK formula, start with your edited Excellentable

Then type in the RANK Formula in area you would like to display the outcome:

Type in the complete RANK 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.