Reverse order of numbers in a column

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.
 
G

Guest

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
Reverse Order 1
Column Order Reversal... 3
sorting numbers and numbers that contain text in excel 2
excel copy and paste... 2
Column multiplied by a matrix 2
Place numbers in ascending order 2
How to determine the text selection? 7

Top