Numerating Cells.

G

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top