View Single Post
  #2  
Old May 30th, 2010, 02:16 AM posted to microsoft.public.excel.newusers
Brad
external usenet poster
 
Posts: 943
Default Reverse Row Order?

One easy way
Insert a column to the left of the data
input 1 in the first cell
input 2 in the second cell
input 3 in the third cell

copy this down so that the number continually increase

Sort the new column and the orginal data by the first column in descending
order.
--
Wag more, bark less


"trvlnmny" wrote:

I have a file where each row contains data about a geographic
location. The order they are in is south to north. I now have a need
to reverse the order. That is have them now list north to south.
Thanks for your help.
.