ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reverse order of numbers in a column (https://www.excelbanter.com/excel-discussion-misc-queries/98392-reverse-order-numbers-column.html)

rcc

Reverse order of numbers in a column
 
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.

JMB

Reverse order of numbers in a column
 
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.

"rcc" wrote:

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.



All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com