change order of items on a list

[rookie37]

I need to reverse the order of a list. Apple, Banana, Carrot, Date would create another list of reverse order. The list would have in it; Date, Carrot, Banana, Apple.

The length of these lists vary. Sometimes the list will have 3 items in it. Sometime the list will have 17 items in it. How do I write a program that will create this second list?

[rookie37]

Sorry to double post. I couldn't find the other one. Therefore I thought that it didn't go through

[boopathiraja]

hI, Assuming list in column a,

Please Login or Register  to view this content.

[boopathiraja]

Ref the attachment..

[boopathiraja]

Hi, Just saw the msg....

If you feel the thread is in the wrong forum and needs to be moved to another forum, PM a mod / admin to do it for you.

http://www.excelforum.com/forum-rule...rum-rules.html