Hi everyone!

I was looking for a vba code to rank and number in a column but i could'nt find it.
This is an example of what i want to do (values in column A);

200% 2
225% 1
150% 3
80%
125% 4
25%
110% 5


So the code only must insert a ranking of 1 to 5 in column B


I hope you can help me, thank you!