Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

sort

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
maxsquires - 15 Jun 2006 18:39 GMT
I am trying to sort two columns at the same time.  

I understand the basic sorting technique but am having trouble when it
comes to sorting the second column.
I have an x coordinate column and a y coordinate column.  I want to
have the spreadsheet display the records in order of x,y coordinate
from upper left to lower right.  That would mean sorting the x values
ascending then the y values descending.  I had hoped that the result of
the sort would be sequential x values followed by the next further down
y values continuing the increas, left-to-right of the x values.  But
this is not happening.  I don't know why.  Any ideas?

THanks

Max

Signature

maxsquires

CLR - 15 Jun 2006 19:19 GMT
Please post a small example (not an attachment), of what you want to see, and
what you're getting now.

Vaya con Dios,
Chuck, CABGx3

> I am trying to sort two columns at the same time.  
>
[quoted text clipped - 11 lines]
>
> Max
Bernard Liengme - 15 Jun 2006 19:28 GMT
Try a two-step process:
Sort the dataset using the Y columns as key
Then sort it using the X column
I assume you want
2 5
3 6
2 4
3 3
to become
2 4
2 5
3 3
3 6

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> I am trying to sort two columns at the same time.
>
[quoted text clipped - 11 lines]
>
> Max
maxsquires - 03 Jul 2006 12:38 GMT
that's right.  i have tried two part sorting and it doesn't work for me.
could it be a glitch or something related to the dbf file format?

Signature

maxsquires

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.