Thread: How do I flip the order of a column? (it is sequintial, so not sor
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I flip the order of a column? (it is sequintial, so not sor
One more method.

Assume your data is in A1:A30

In B1 enter =INDEX($A$1:$A$30,30-(ROW(A1)-1))

Copy down to B30


Gord Dibben MS Excel MVP


On Sun, 17 Dec 2006 06:31:00 -0800, justjessica
wrote:

I want to invert my text so that the bottom is the top and the top is the
bottom. It is not sequential so normal sort is not working.

Reply With QuoteReply With Quote