+ Reply to Thread
Results 1 to 2 of 2

Sorting two lists of names with different values

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Sorting two lists of names with different values

    I have two lists of employee names. Each list contain some employee names that are the same while personnel changes have cause one list to have more names than the other. I would like to be able to sort each list and have them match up the names next to each other while putting the non-matching names at the bottom of the list. Example:

    List 1
    Joe Blow
    John Doe
    Jane Doe
    Joe Bag'O'Doughnuts

    List 2
    John Doe
    Joe Bag'O'Doughnuts
    Mickey Mouse
    Minnie Mouse
    Jane Doe

    I would like to put each list in a column next to each other and have excel 1. Sort them so the names match up, and 2. Eliminate non-matching names by dropping them down to the bottom or top of the list.

    Is this even possible? Does it make sense?

    Thanks in advance for your help.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Sorting two lists of names with different values

    try the macro
    Attached Files Attached Files

+ 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