Finding a Ranking formula

[richardthelionheart]

COL A
22.2
77.7
44.4
88.8
55.5
33.3

COL A COL B
22.2 6
77.7 2
44.4 4
88.8 1
55.5 3
33.3 5


I'm looking for a formula where I can rank all the numbers/values in column A and have them show up in column B.
I can solve this myself using 6 columns to the right and 'IF' statements etc but I wondered if there was a short cut
formula which used perhaps FIND or SEARCH etc which would work. This formula, if it exists, could them be applied
to say 10 rows or 20 or 100. I also know another method which is cumbersome if being applied on a regular basis
which of course is to sort the rows and add in the column B entries which I'm trying to circumvent because it is far
too time consuming when faced with say 1000 sets of numbers.

Any assistance greatly appreciated.

 

[Aladin Akyurek]

In B2 enter and copy down:

=RANK(A2,$A$2:$A$7)

 

[richardthelionheart]

Actually I did not know 'rank' existed. Thank you Aladin.

 

[Aladin Akyurek]

Actually I did not know 'rank' existed. Thank you Aladin.

You are welcome.