=RANK(B2,B:B)

and fill it down!

Regards,
Stefi

€žLiAD€� ezt Ã*rta:

maybe this will have a very similar solution to my first question.

If I have a range of data such as below which i want excel to tell me which
is the biggest and call it 1st, the second biggest 2nd etc.

inputs ouput
a 3 3rd
b 6 1st
c 1 4th
d 4 2nd

I do not know yet how long my list of data will be, somehwere between 6 and
10 rows i guess so its not much.

Any ideas on this one as well?

Thanks