+ Reply to Thread
Results 1 to 6 of 6

Group/sort rows based on values in multiple columns?

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    21

    Group/sort rows based on values in multiple columns?

    Hi all,

    I have a spreadsheet that shows ID numbers in column A, and then multiple differing values in columns D through X. I'd like to sort or somehow group those IDs which share the same values in their columns D through X, so they can be assigned to share templates in another system.

    If there weren't so many columns of values, I'd just do a Sort By / Then By / Then By, but with 21 columns, it's tricky. Surely there's some kind-of simple way. What can I do?

    Thank you,

    T.
    Last edited by teitoku; 08-10-2012 at 11:21 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,438

    Re: Group/sort rows based on values in multiple columns?

    You get better help if you post an Excel-example of your workbook, without confidential information.

    Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

    Use BEFORE/AFTER sheets if that helps make it clearer.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    Nashville
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Group/sort rows based on values in multiple columns?

    Have you considered creating a sorting field, where it contains the concatinated vales of the cells you want to sort?

  4. #4
    Registered User
    Join Date
    08-25-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Group/sort rows based on values in multiple columns?

    Quote Originally Posted by oeldere View Post
    You get better help if you post an Excel-example of your workbook, without confidential information.
    I've tried in three different browsers, but each time I click Manage Attachments, a blank page is loaded. Sorry.

    Quote Originally Posted by gsniadak View Post
    Have you considered creating a sorting field, where it contains the concatenated vales of the cells you want to sort?

    How so? Like.. summing the values of the rows and sorting by that sum?

  5. #5
    Registered User
    Join Date
    08-06-2012
    Location
    Nashville
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Group/sort rows based on values in multiple columns?

    No, not summing, concatinating.
    Summing would be A1 + A2; concatinating would be A1 & A2. It joins multiple text values together into a single value

  6. #6
    Registered User
    Join Date
    08-25-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Group/sort rows based on values in multiple columns?

    Excellent idea! I'll see how that goes over.

    edit: Seems to work. With 15,000+ rows, though, it's hard to be sure. I did your concatenate method, then Advanced Filtered out unique records, and it looks like there are about 400 different combos of values.
    Last edited by teitoku; 08-07-2012 at 02:35 PM. Reason: updated info available

+ 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