On Aug 27, 2:10�pm, Denish D <Denish
wrote:
How to reverse data of a single column?

Example:
Column
2254
245
148
224
2515
8476
47
5647

My question is " what to do if i want to these column values as shown below :

5647
47
8476
2515
224
148
245
2254


In an adjacent column (insert one if necessary) enter . . .

=ROW()

.. . . in every cel which has one of your numbers in it.

Then select all the cels of both columns.

Select DATA SORT

Select the column of the =ROW() cells

Select Descending if not already selected

Click OK.

Repeat to revert.

Alan Lloyd