In This Topic

RANK.AVG

In This Topic

This function returns the rank of a number in a set of numbers.

RANK.AVG(*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) |

The size of the returned number is relative to other values in the list. The average rank is returned if more than one value has the same rank.

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

RANK.AVG(B3,B1:B8,1)

RANK.AVG(R3C2,R1C2:R8C2,1)

This function is available in Spread for Windows Forms 11.0 or later.

See Also