Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    Sorting help (2003)

    A user has a spreadsheet that updates with new vendor information each month. THe way he has the spreadsheet set up, the vendor name is in a row with its corresponding account information in the rows beneath it. There are several vendors. He wants to sort by vendor, but when he does, all the vendor names show at the top and the account information is sorted at the bottom (see attached file for sample). This data is populated into the spreadsheet automatically every month, so he doesn't want to have to copy/move the data each month to get it to sort right (and he doesn't want anything to do with code). I told him that he could copy the vendor name into a "hidden" column and repeat it for each row of corresponding account info and then sort that way. He asked if there is a better way to do this.

    So, I am submitting a sample of the spreadsheet he has and am asking you kind people to take a look and tell me how (without code if possible), we can get this data to sort by vendor name and keep each vendor's associated account information with the right vendor.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Sorting help (2003)

    This is similar to what you suggested: You can add this formula in a hidden column in row6:

    and copy it down all the rows.

    Then use this column as the primary sort


Posting Permissions

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