starting in the column to the right the row that has "1" in it, type "a",
then next to "2", type "b", etc. to "5" which should be "e", then copy/paste
down the entire column.

Then you can sort ascending by the first column & descending by the second
column.

Hope this makes sense.

"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?