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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint 2011 powerpoint for Mac upside down presenter view boxes 0
Can one turn a color laser printer upside down 4
Xbox Series X anomaly (sort of) 4
turn form upside down 1
Parse a column using a VLOOKUP Table and post a result to another cell/column 1
Screen Upside Down Virus 4
Converting Letters To Numbers Summary??? 2
In a sales quote sheet - sum totals by license type 1

Back
Top