|
|
Descending Order
The
following formula, entered in C2 and copied down, returns the
unique ranking in descending order for the values in B2:B10...
=RANK(B2,$B$2:$B$10,0)+COUNTIF($B$2:B2,B2)-1
Based on the sample data, the formula returns the values in C2:C10.
Sample
Workbook
|
Ascending Order
The
following formula, entered in C2 and copied down, returns the
unique ranking in ascending order for the values in B2:B10...
=RANK(B2,$B$2:$B$10,1)+COUNTIF($B$2:B2,B2)-1
Based on the sample data, the formula returns the values in C2:C10.
Sample
Workbook |
|
|
