Hi

Look at the Rank() function, insert the formula below in B1 and copy
it down.

=RANK(A1;$A$1:$A$4)

Regards,
Per

On 4 Aug., 20:46, 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.