| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
reverse data
I have a column of price data which is random however it is in reverse order,
that is the cells that are down the bottom need to be up the top and vice versa, how do I reverse the data without sorting it and getting it out of sequence? |
|
#2
|
|||
|
|||
|
Assuming the data is in column A enter this formula in B1 and copy down:
=INDIRECT("A"&21-ROW()) Adjust the 21 based on the number of records you have. This should be one more than the number of records so in my example the data was in A1:A20. Hope this helps Rowan megsie jack wrote: I have a column of price data which is random however it is in reverse order, that is the cells that are down the bottom need to be up the top and vice versa, how do I reverse the data without sorting it and getting it out of sequence? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| How do I quickly reverse the order of a set of data | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
