RANK.EQ

Returns the rank of a specified value in a data set. If there is more than one entry of the same value in the data set, the top rank of the entries will be returned.

Sample usage

RANK.EQ(A10, A1:A100, TRUE)

RANK.EQ(B32, B8:B47, FALSE)

RANK.EQ(A10, A1:A100)

Syntax

RANK.EQ(value, data, [is_ascending])

  • value – The value whose rank will be determined.
  • data – The array or range containing the data set to consider.
  • is_ascending – [ OPTIONAL – default is descending (FALSE) ] – Whether to consider the values in data in descending or ascending order.

See also

RANK: Returns the rank of a specified value in a data set.

RANK.AVG: Returns the rank of a specified value in a data set. If there is more than one entry of the same value in the data set, the average rank of the entries will be returned.

Need more help?

Try these next steps:

Post to the Help Community Get answers from community members
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
12418442961753012540
true
Search Help Centre
true
true
true
true
true
35
false
false