In Excel, rank is a value that represents the position ... 0 is the default and can be omitted: ranks in descending order. Any nonzero numerical value ranks ref as if is sorted in ascending ...

while any non-zero value ranks ref in descending order. Microsoft Excel’s RANK.EQ() function replaces the older RANK() function but performs the same as RANK(). To learn more about RANK.EQ ...