Inverting a data column

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

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.

--
Regards,
Tom Ogilvy

"Desmo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Desmo
> ------------------------------------------------------------------------
> Desmo's Profile:
http://www.excelforum.com/member.php...o&userid=25726
> View this thread: http://www.excelforum.com/showthread...hreadid=391357
>

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

On Fri, 29 Jul 2005 14:32:51 -0400, "Tom Ogilvy" <[email protected]> wrote:

>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.

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

Mike

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
news:[email protected]...
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

On Fri, 29 Jul 2005 14:32:51 -0400, "Tom Ogilvy" <[email protected]> wrote:

>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.

Thanks RD

Gord

On Sat, 30 Jul 2005 15:46:54 -0700, "RagDyeR" <[email protected]> wrote:

>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))