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?

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?

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?

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

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

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

On May 19, 2:58*am, Tom Hutchins
wrote:
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



"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?- Hide quoted text -

- Show quoted text -