new column which numerically ranks numbers from lowest to highest

[Haydo]

On an excel sheet, I have lists of numbers which appear like this in different columns, and there are different sets of numbers with black rows in between.

48
127.54
137.54
68
98
9.45
890.5
1.89
2.35
6.7


i would like to have a 'ranking order' from lowest to highest, in a new column which places a '1' adjacent to the lowest number, '2' adjacent to the 2nd lowest number, etc
It will look like this.

please note - the equal 8th lowest shared by 2 numbers. If two numbers are equal i would prefer this equal option if possible.

48 5
127.54 8
127.54 8
68 6
98 7
9.45 4
890.5 10
1.89 1
2.35 2
6.7 3


I have separate sets of numbers (separated by blank rows) on the same sheet which i would like to apply this code/function to SEPARATELY. (each set of numbers has its own rank from lowest to highest) I can make adjustments to the function/code to apply to the row/column numbers if required.

Is there a function for this task? Is it best to use code? If so, if someone could assist me with a code, I would greatly appreciate it.

 

[mumps]

Assuming your numbers are in column A starting in row 1, place this formula in B1 and copy it down column B as far as you need it.
=IFERROR(RANK(A1,$A$1:$A$20,1),"")

 

[Haydo]

Thank you. I have started working with this. I will need some time to work it out for all the options, but it is producing a good result. Cheers.

 

[mumps]

You are very welcome.

 

[Amanda Wilso]

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

or


Click a cell in one of the columns That You want to sort.
Data in adjacent columns will be sorted based on the column That You sort.
On the Data tab, under Sort & Filter, click the arrow next to Sort.