Inverting a data column

[Desmo]

Greetings,

I am attempting to invert a column of numeric data (4000-entries)
without choosing ascending or descending order as the data has no
numeric order.

Is there a command or serise of commands to use without writing a
formula to erform the action?

Thanks,

Mike

 

[swatsp0p]

There may be neater solutions, but until something better comes along,
you can accomplish this by using a couple of helper columns. Assuming
your data is in Column A, starting in A1, insert blank Columns B & C.
In C2 enter -1, in C3 enter -2. Highlight these two cells and drag to
the last row of the range of data in A (the numbers should decrease -3,
-4....-nnn). Then in B1 enter this formula:

=Annn [where nnn is the number of the last row in your data set, e.g.
=A4000]

In B2, enter this formula:

=OFFSET($A$nnn,C2,0) [again, nnn is the last row]

copy this formula down to row nnn

Does this work for you?

Bruce

 

[Tom Ogilvy]

Easiest in my opinion is to put 1 in an adjacent cell in the first row, 2 in
the second row, then select 1 and 2 and drag fill down to the last (4000th
cell). Then select both columns and sort descending on the new numbers.
You could insert a column for this, then delete it.

 

[Gord Dibben]

Even easier is to enter the 1 and 2 as Tom suggests then select those two
cells and double-click on the fill-handle(bottom-right corner of cell).

No dragging involved if adjacent column has contiguous data to row 4000.


Gord Dibben Excel MVP

 

[Desmo]

Looks like you've hit the bulls eye... thanks for the assist.

Mike

 

[RagDyeR]

I'll play that game Gord.<g>

*Even easier*, is to enter this formula, and double click the fill handle.
and return *immediate* results, *no sorting* necessary:

=INDEX($A$1:$A$4000,4000-(ROW(A1)-1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Even easier is to enter the 1 and 2 as Tom suggests then select those two
cells and double-click on the fill-handle(bottom-right corner of cell).

No dragging involved if adjacent column has contiguous data to row 4000.


Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks RD

Gord