Inverting a column

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Is it possible to invert a column of numbers, so that the
top number is at the bottom, and the bottom number is at
the top?
 
Without writing your own function to do it the standard workaround is to
add another column beside your data numbered 1 to the length of your
data ,select both columns and sort on the second column descending to
reverse the order of the first column.
 
If your existing Column Data is in Column E (say E2:E21) in Column F (Insert
if necessary) enter into cell F2 and Copy Down to F21:

=OFFSET(E$2,COUNTA(E$2:E$21)+1-ROW(),0,1,1)
 
Hi Joe,

Select one of the cells in the column and then click on Data and then Sort.
There is also an icon on the toolbar which will do this for you. This will
sort A-Z or 1-9 or the reverse.

Best Regards,

CalumMurdo Kennedy
www.taekwondo.freeserve.co.uk
 
Back
Top