MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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.