Here is an easy way. If, for example, your consecutive numbers are in
A1:A500...
In B1 enter =A5
In B2 enter =A4
In B3 enter =A3
In B4 enter =A2
In B5 enter =A1

Select B1:B5. Right-click and select Copy. Now highlight B6:B500.
Right-click and select Paste. Select all of column B, then copy & paste it in
place as values (Paste Special Values).

Hope this helps,

Hutch

"ME Cochran" wrote:

I have a list of consecutive numbers in a column from say 1 to 500. Does
anyone know an easy way to take these numbers in a new column and sort them
to be 5, 4 ,3 , 2, 1, 10, 9, 8, 7, 6, 15, 14, 13, 12, 11, and so on?