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