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?

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.