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 -