Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |