ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I invert a column in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/70274-how-do-i-invert-column-excel.html)

3-togo

How do I invert a column in Excel?
 
I am looking for a quick way to invert a column in Excel.

pinmaster

How do I invert a column in Excel?
 
One way.

In a blank adjacent column type 1 and 2 in the first 2 cells then select the
2 cells and drag down to the last row with data, next select the 2 columns
and sort using the new column in descending order.....clear the the new
column when done.

HTH
JG

"3-togo" wrote:

I am looking for a quick way to invert a column in Excel.



All times are GMT +1. The time now is 07:08 PM.

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