Ranking based on values in a column

[Rportz]

I am trying to rank the percentages in column A in column B. Since 200% is the highest, it would be ranked #1 . Can someone help? Thank you.

Column A	Column B
200%	1
10%	2
50%	3
87%	2

<tbody>
</tbody>

 

[Eric W]

Would the RANK function work for you?

	A	B	C
1	Column A	Column B
2	200%	1
3	10%	4
4	50%	3
5	87%	2

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =RANK(A2,$A$2:$A5) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Rportz]

I so appreciate you!!!

 

[Eric W]

You're welcome! Thanks for the feedback.