RANK.EQ(number, ref [,order])

Returns the rank of a value in a list, table or cell range (in descending order) (equal ranking).

numberThe number whose rank you want to find.
refThe array, or a reference to, a list of numbers.
order(Optional) The number indicating how the list of numbers is sorted:
0 = largest number has a rank of 1 (default)
1 = smallest number has a rank of 1

Remarks

* Added in Excel 2010.
* This function replaces the RANK function.
* If more than one value has the same rank, then equal ranking is used.
* For an illustrated example refer to the page under Advanced Functions.
* You can use the RANK.AVG function to return average ranking when more than one value has the same rank.
* You can use the LARGE function to return the kth largest value in a list or array of numbers.
* You can use the SMALL function to return the kth smallest value in a list or array of numbers.
* For the Microsoft documentation refer to support.office.com

 AB
1???? 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top