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.
Bookmarks