# Sorting a list of numbers

M

#### ME Cochran

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?

B

#### beckiewhite

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.

T

#### Tom Hutchins

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

T

#### Tom Hutchins

Here is another way. If your consecutive numbers are in A1:A500, in B1 enter
=IF(MOD(A1,5)=0,A1-5,(INT(A1/5)*5)+(5-MOD(A1,5)))+1

Copy this formula down through B500.

Hope this helps,

Hutch

P

#### Pete_UK

Another way - put this in B1:

=(INT((A1-1)/5)+1)*5+1-A1+INT((A1-1)/5)*5

and copy down. Then you can sort the data using column B as the key
field.

Hope this helps.

Pete