How to reverse data of a single column?

[Denish D]

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

please reply..

 

[NBVC]

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

please reply..

In available column add formula:

=INDEX($A$1:$A$8,ROWS($A$1:$A$8)-ROW()+1)

where A1:A8 is the entire original range... then copy down

You can then copy and edit|Paste Special >> Values over the original
and delete the helper column, if desired.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[Luke M]

Select just that column of info. Data - Sort, descending. If prompted, keep
current selection.

 

[Eduardo]

Hi,
use another column to number your data, let's say starting from 20 all the
way down to 1 and then highlight all the columns and filter them by the
column created in ascending order, then delete this column

if this helps please click yes thanks

 

[Luke M]

Apologies, I did not see the 2nd half of your post. It looks like Eduardo or
NBVC hae suggested a practical solution.

 

[Ron Rosenfeld]

On Thu, 27 Aug 2009 06:10:02 -0700, Denish D <Denish

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

please reply..

=IF(ROWS($1:1)>ROWS(rng),"",INDEX(rng,ROWS(rng)+1-ROWS($1:1)))

where "rng" is the named range where your data exists.

Fill down until getting blanks.
--ron

 

[alanglloyd]

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