Numerating Cells.

[GEM]

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.

 

[Luke M]

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

Copy down as needed.

 

[Per Jessen]

Hi

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

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

Regards,
Per