ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Changing the Direction of Data within a Column (https://www.excelbanter.com/excel-worksheet-functions/10274-changing-direction-data-within-column.html)

Michael Parsons

Changing the Direction of Data within a Column
 
This may sound simple, but have exhausted all means...perhaps not seeing the
solution for the "Trees". If I have...say 300 events in a column, numbers
range from 15.6 to 15.9 in any order and I want to reverse (not sort) that
column where the last event is the now the first, what do I need to make this
happen? Again, it is not sorting Ascend/Descend, it is changing the order
the events are displayed within the given column.

Any assistance would be greatly appreciated.

Michael R. Parsons


Otto Moehrbach

Michael
Add a blank column to one side of that column. Fill that column from 1
to however many entries you have in the first column. Sort both columns
together, sorting on the column you just put in. Sort Descending. Delete
the helper column. HTH Otto
"Michael Parsons" <Michael wrote in
message ...
This may sound simple, but have exhausted all means...perhaps not seeing
the
solution for the "Trees". If I have...say 300 events in a column, numbers
range from 15.6 to 15.9 in any order and I want to reverse (not sort) that
column where the last event is the now the first, what do I need to make
this
happen? Again, it is not sorting Ascend/Descend, it is changing the order
the events are displayed within the given column.

Any assistance would be greatly appreciated.

Michael R. Parsons





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

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