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?