I want the items in the A column in reverse order in the B column.

[Guest]

I have a list of items in cells A1-A100 that are in the reverse order I need
them in. So, in the B column I want cell B1 to equal to A100, B2 =A99, etc.

 

[Don Guillett]

Have you tried sorting?

--
Don Guillett
SalesAid Software
(e-mail address removed)

I have a list of items in cells A1-A100 that are in the reverse order I need
them in. So, in the B column I want cell B1 to equal to A100, B2 =A99,

etc.

 

[Frank Kabel]

Hi
in B1 enter
=OFFSET($A$100,-(ROW()-1),0)

--
Regards
Frank Kabel
Frankfurt, Germany

I have a list of items in cells A1-A100 that are in the reverse order I need
them in. So, in the B column I want cell B1 to equal to A100, B2

=A99, etc.

 

[Otto Moehrbach]

In B1 enter a 1. Drag this down, with Ctrl key held down, as far as Column
A data goes. Sort both columns together, sorting on Column B, descending.
Delete or erase Column B. HTH Otto