|
|
Descending
Order
The
following formula, entered in C2 and copied down, returns
the consecutive ranking in descending order for the values in B2:B10...
=SUM(IF(B2<$B$2:$B$10,1/COUNTIF($B$2:$B$10,$B$2:$B$10)))+1
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
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 consecutive ranking in ascending order for the values in B2:B10...
=SUM(IF(B2>$B$2:$B$10,1/COUNTIF($B$2:$B$10,$B$2:$B$10)))+1
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formula returns the values in C2:C10.
Sample
Workbook
|
|
|
