Changing the Direction of Data within a Column

M

Michael Parsons

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
(e-mail address removed)
 
O

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
 

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

Multi column sort issue within Pivot table 0
Ascending Sort formula, change to neg #: descending sort.. 6
auto sorting help needed thank you! 2
bug in sort routines 2
Copy column to new sheet and update 0
2 Dim Array Sort, on any columns, ascend or descend. Guidance des 0
Dynamcially change sort order on continuous form 5
Excel 2003 - bar chart - data source question 0

Top