+ Reply to Thread
Results 1 to 4 of 4

Sort function

  1. #1
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Sort function

    This may sound terribly elementary, but I am unable to sort by two different columns. I want to sort by one, then sort by another. Should be basic, right? It is only sorting by the first criteria. Any ideas?

  2. #2
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302
    "(Menu) Data: Sort" pops up a form for entering columns to sort on.
    The first field gives the primary column. The rows will sort into order according to the primary.

    The second field gives the secondary column. This is used to sort rows for same-values in the primary column, to break ties.

    There is a third field that can be used to break ties for same-values in the first two columns specified.
    FrankBoston is the pen name for Andrew Garland, Lexington MA

  3. #3
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    no doubt

    That is correct. I have already done so using the primary and secondary sorts. The problem is, it is not sorting by the secondary at all.

  4. #4
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302
    Now it is time to upload an example, a zipped .XLS.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1