Sort/Rank Numeric Values with Duplicate Values Exist
Excel built-in RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest number, so there are two “3” in the sort column and there is no number… read more »