RANK.EQ()

Syntax. RANK.EQ(number,ref,order)

Definition. This function returns the rank of a number within a list of numbers. The rank of a number is its size relative to the other values in a list. If you were to sort the list, the rank of the number would be its position.

Arguments

• number (required). The value for which you want to know the rank.

• ref (required). An array of or a reference to a list of numbers. Nonnumeric values in ref are ignored.

• order (optional). A number specifying how to rank numbers. If order is 0 or not specified, the number is ranked as if ref were a list sorted in descending order. If order is a nonzero value, the number is ranked as if ref were a list sorted in ascending order.

Background. You will find more information in the description of RANK().

Example. For information about the use of the RANK.EQ() function, see the example for the RANK() function.

Sample Files

Use the RANK.EQ worksheet in the Count.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.