![]() |
How do I invert a column in Excel?
I am looking for a quick way to invert a column in Excel.
|
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