Reverse order in column

[Guest]

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

 

[Alan]

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

 

[Ragdyer]

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

 

[Aladin Akyurek]

In B2 enter & copy down as far as needed:

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

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.