turning data around

Posted by sean on January 28, 2002 9:08 AM

hi there,

I have several columns of data. The numbers are not in ascending or descending order. How can I flip the data about so that the last cells are now the first without sorting the data into ascending or descending values?

thanks

Posted by Mark W. on January 28, 2002 9:13 AM

In an unused column number your rows using the
function , =ROW(). Sort Descending on the newly
created column.