Thread: data inversion!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default data inversion!

On Sat, 6 May 2006 13:30:20 -0500, via135
wrote:


hi!

how can i make the data, say, in the first 3 rows
gets inverted..may be in another area of the sheet.?

hlp pl?

-via135



If I've understood your requirement, one way would be to use a helper
column and number the rows 1,2 & 3. then sort the data including the
helper column with a descending operator. Then if required, Copy (or
cut) and paste to wherever you want.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________