Upside down...

  • Thread starter Thread starter confused man
  • Start date Start date
C

confused man

Hello all,

I have a column of data that is arranged in a column... is it possible to
copy that column and have the bottom value be on top and the top value be on
the bottom, effectively turning the column upside down?

Thank you so much,
Confused Man
 
Man,

Put consecutive numbers in an adjacent column (Put 1, then drag down with
the fill handle and Ctrl key). Now sort the two columns in descending order
on the helper column. Be careful if there's other data nearby, as Excel
sorts can mess up your worksheet. Now trash the helper column.
 
Thanks! Just what I needed

Confused Man

Earl Kiosterud said:
Man,

Put consecutive numbers in an adjacent column (Put 1, then drag down with
the fill handle and Ctrl key). Now sort the two columns in descending order
on the helper column. Be careful if there's other data nearby, as Excel
sorts can mess up your worksheet. Now trash the helper column.
Click to expand...
 
Back
Top