Sorting a list of numbers

  • Thread starter Thread starter ME Cochran
  • Start date Start date
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?
 
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.
 
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
 
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
 
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
 
Back
Top