Ranking

hi all, can you pls help me out with this?
i think it is if statement but i am not sure

lets say i have random numbers on any column. this random number changes every time you press any key.

my problem is, i need to put them in order. lets say
A B
7
6
12 6
11
3
2 1
th biggest number should get 6 and the smallest 1 on the other column.
since the numbers change, the order must be change too...

how can i do this..any idea???

thanks a lot... it is so simple but i doest come fast to mind sometimes...thanks a lot again