reverse data

G

Guest

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?
 
R

Rowan Drummond

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
 

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

paste in Reverse Order 3
How do I reverse the order of a column or row? 3
Reverse Order 3
FORMULA Sorts neg numbers as positive.. 2
Sorting Rows- Reverse 7
Cannot sort data 1
Reverse column order with a macro 3
Reversed Array 9

Top