Returns the rank of a number in a list of numbers
Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned.
If you were to sort the list, the rank of the number would be its position.
2 required arguments and
1 optional argument:
The arguments for the RANK.EQ function are:
||The number whose rank you want to find.
||An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
||A number specifying how to rank number.