A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Reverse Row Order?



 
 
Thread Tools Display Modes
  #1  
Old May 29th, 2010, 10:14 PM posted to microsoft.public.excel.newusers
trvlnmny
external usenet poster
 
Posts: 39
Default Reverse Row Order?

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.
  #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.
.

  #3  
Old May 30th, 2010, 02:20 AM posted to microsoft.public.excel.newusers
L. Howard Kittle
external usenet poster
 
Posts: 516
Default Reverse Row Order?

Try this.

In the next column enter 1 and pull down to whatever, the end of the list.

Select both columns and sort Decending by the numbered column. Delete
numbered column.

HTH
Regards,
Howard

"trvlnmny" wrote in message
...
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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.