Spread Formula Reference
Formula Functions / Functions R to S / RANK.AVG
In This Topic
    RANK.AVG
    In This Topic

    Summary

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

    Syntax

    RANK.AVG(number,array,order)

    Arguments

    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)

    Remarks

    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.

    Data Types

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

    Examples

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

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

    Version Available

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

    See Also