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

P

pauliep

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

Don Guillett

Have you tried sorting?

--
Don Guillett
SalesAid Software
[email protected]
pauliep said:
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,
Click to expand...
etc.
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

pauliep said:
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
Click to expand...
=A99, etc.
 
O

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
 
Top