Reverse order of numbers in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I reverse the order of numbers in a column?
i.e. My column contains [1 4 6 3 2] and I want it to contain [2 3 6 4 1].

Thank you.
 
in a column next to it, put 1, 2 and fill down. then sort both columns using
this new column, sort descending, delete the helper column.
 

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

Reverse Order 2
Column Order Reversal... 3
excel copy and paste... 2
Numbers from first column 5
Order numbers from smallest to largest 6
How to reverse code data (1=5, 2=4, etc.)? 5
paste in Reverse Order 3
Split column contents (de-concantenate) 7

Back
Top