i have a 10 columns of about 100 rows. I am trying to rank each column.
example.

column A has 5 rows. and each row has a number. I want column B to rank
them.
A B

1 50.2 4
2 37.1 1
3 40.1 2
4 40.1 2
5 50.1 3 the way ive been
doing it is sort the column then maunally rank them in order. I gets
tiresome doing over 100 mumbers per column.
Thanks for your time..