In This Topic

RANK

In This Topic

This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list.

RANK(*number*,*array*,*order*)

This function has these arguments:

Argument | Description |
---|---|

number |
Number whose rank you want to return |

array |
Reference to the set of numbers |

order |
[Optional] How the number is ranked, either in descending order (0 or omitted) or ascending order (non-zero value) |

This function gives duplicate numbers the same rank. The presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers, if the number 12 appears twice and has a rank of 4, then 13 would have a rank of 6 (no number would have a rank of 5).

Accepts numeric data for the *number* argument, a reference for the *array* argument, and numeric data for the *order* argument. Returns numeric data.

RANK(B3,B1:B8,1)

RANK(R3C2,R1C2:R8C2,1)

See Also