RANK.EQ
StatisticalExcel 2010The rank of a number in a list; equal values share the top rank.
Syntax
RANK.EQ(number, ref, [order])
Arguments
- number
- The value to rank.
- ref
- The list of numbers.
- orderoptional
- 0 / omitted = largest is rank 1; 1 = smallest is rank 1.
Examples
=RANK.EQ(B2, $B$2:$B$100)
→
Good to know
- Add COUNTIF(...) to break ties, or use RANK.AVG for average ranks.
Related functions
More Statistical functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.