Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Sorting Unique Items Over 2 Columns

    In column A, I have > 100 names, some of which are duplicates. In column B I have contract numbers associated with the name in column A, with some of the names having more than one unique contract number associated with it. What I would like to do is create a third list in columns C & D that would list all of the names and their associated contract numbers. Any help?Thanks in advance.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Manning, South Carolina
    Thanked 1,455 Times in 1,324 Posts

    I'm not exactly sure what you want the new list to look like an example might help.
    You might also want to look into using a Pivot Table do do the aggregation, especially if there are multiples, e.g. More that one contract number per name and more than one name per contract number.
    May the Forces of good computing be with you!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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