How to get reverse company name?

[niladri20052006]

Hi All,

I have a list of company names A2, A3, A4 and so on like below:

Mentor Graphics Corporation
ArvinMeritor, Inc.
Wilmington Trust Corporation
Nestle Waters North America Inc.
Keystone Foods LLC
Hot Topic, Inc.

I want the company names in reverse wise like :
Hot Topic, Inc.
Keystone Foods LLC
Nestle Waters North America Inc.
Wilmington Trust Corporation
ArvinMeritor, Inc.
Mentor Graphics Corporation

Is there any way to do that?

 

[shg]

In a convenient column, enter 1, 2

Select both cells and drag down.

Sort the ensemble by that column descending.

 

[West Man]

If sorting is not an option and you wish them in reverse order in another column: Assuming your data is in A4:A9 you could try in B4 and dragged down
=INDIRECT("A"&(COUNTA($A4:$A$9)+ROW(B$3)))