Reverse order in column

If they're in numerical order, as your example, simply select them and then
sort them "descending".
If they're not in any order, then add a "helper" column, and number it from
1 to whatever, THEN, select both columns, and sort on the helper column
"descending".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"D" <[email protected]> wrote in message
news:[email protected]...
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

One way is to use a use a helper column,
In column B enter 1 in B2 ,2 in B3 and carry on to the end of your range,
then sort both columns by column B, delete or clear contents of column B
when done
Regards,
Alan
"D" <[email protected]> wrote in message
news:[email protected]...
>I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

In B2 enter & copy down as far as needed:

=INDEX($A$2:$A$4,ROWS($A$2:$A$4)-(ROW()-ROW(B$2)))

D wrote:
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

If they're in numerical order, as your example, simply select them and then
sort them "descending".
If they're not in any order, then add a "helper" column, and number it from
1 to whatever, THEN, select both columns, and sort on the helper column
"descending".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"D" <[email protected]> wrote in message
news:[email protected]...
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

One way is to use a use a helper column,
In column B enter 1 in B2 ,2 in B3 and carry on to the end of your range,
then sort both columns by column B, delete or clear contents of column B
when done
Regards,
Alan
"D" <[email protected]> wrote in message
news:[email protected]...
>I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

In B2 enter & copy down as far as needed:

=INDEX($A$2:$A$4,ROWS($A$2:$A$4)-(ROW()-ROW(B$2)))

D wrote:
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

I have a long colum on numbers, I would like to put them in reverse order.

i.e. A2 has 101
A3 has 103
A4 has 105

Reversed to:
A2 105
A3 103
A4 101

Etc.

Thanks

Don

If they're in numerical order, as your example, simply select them and then
sort them "descending".
If they're not in any order, then add a "helper" column, and number it from
1 to whatever, THEN, select both columns, and sort on the helper column
"descending".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"D" <[email protected]> wrote in message
news:[email protected]...
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

One way is to use a use a helper column,
In column B enter 1 in B2 ,2 in B3 and carry on to the end of your range,
then sort both columns by column B, delete or clear contents of column B
when done
Regards,
Alan
"D" <[email protected]> wrote in message
news:[email protected]...
>I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

In B2 enter & copy down as far as needed:

=INDEX($A$2:$A$4,ROWS($A$2:$A$4)-(ROW()-ROW(B$2)))

D wrote:
> I have a long colum on numbers, I would like to put them in reverse order.
>
> i.e. A2 has 101
> A3 has 103
> A4 has 105
>
> Reversed to:
> A2 105
> A3 103
> A4 101
>
> Etc.
>
> Thanks
>
> Don

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.