Not sure how you linked by pasting special, can you tell us which option you used?
One thing that might work here is INDEX(MATCH(RANK)))
ie, suppose A1:A5 contains 5 numbers.
In B1, enter =RANK(A1,$A$1:$A$5) and copy down to B5.
Then in C1:C5, enter 1 2 3 4 5.
Then in D1 enter =INDEX($A$1:$A$5,MATCH($C1,$B$1:$B$5,0)) and copy doen to D5.
D1:D5 should contain the original five numbers sorted from greatest to least. You can manipulate the order by changing the values in C1:C5 or by using SMALL, LARGE and the different settings of RANK, etc.
Hope this helps,