The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

Name: The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).
Brand: Quizplus
Rating: 4.8 (39 reviews)

Question

Quizplus · Accepted Answer

The correct syntax for the RANK.EQ function in Excel is RANK.EQ(number, ref, [order]). The function does not include "sort" as a parameter; instead, it uses "ref" to specify the array or range of data, and "order" is optional to specify ascending or descending order.

The Syntax of the RANK