In B1:
=RANK(A1,$A$1:$A$4)

Copy down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"GEM" wrote:

Is there a way to numerate cells. For example.

A1=20
A2=22
A3=5
A4=12

The results I want in column B are the following
B1=2
B2=1
B3=4
B4=3

Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd
highest and finally A3 is the fourth highest.