View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default how do you invert a column



Chris wrote:
0
1
2
3
4
5

I would like

5
4
3
2
1
0


Hi,
If they are continuously increasing as you have shown then just sort
descending.

If they are not as shown, eg...

4
3
5
2
0
1

and you need ...

1
0
2
5
3
4


then one way is to insert a new column next to it. In the new column
enter a continuously increasing series of numbers. Select both columns
(and any other columns that need to stay with your column) then sort
the new column descending, then delete the inserted column.
eg...


4 1
3 2
5 3
2 4
0 5
1 6

after sort descending becomes...

1 6
0 5
2 4
5 3
3 2
4 1

Ken Johnson