I've got two different list of User IDs that come from two different sources. Some of the User IDs are included in both lists, but many are in one list only. The entries in each list are almost always duplicated. There will eventually be changes to the lists, as employees are hired or leave their roles, so I need a formulaic way of combining the lists, sorting them, and eliminating duplicates.
Here are a sample of my two input tables and the final version I'm trying to create:
I've tried to use the UNIQUE function to identify unique entries and the SORT function to put them in order, but I can't seem to find a way to combine the functions to have them work from both lists.
Is there a way to accomplish what I'm trying to do with formulas?
Thanks!
Here are a sample of my two input tables and the final version I'm trying to create:
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | User ID List 1 - With Duplicates | User ID List 2 - With Duplicates | Desired Output - Complete User List | ||||
2 | AHOOKS | AGONZALEZ | AGONZALEZ | ||||
3 | AHUDSPETH | BAMANTE | AHOOKS | ||||
4 | ALEE | BANDERSON | AHUDSPETH | ||||
5 | BAMANTE | BDORSEY | ALEE | ||||
6 | ALEE | BMINOTT | BAMANTE | ||||
7 | AHOOKS | AGONZALEZ | BANDERSON | ||||
8 | BAMANTE | BDORSEY | BDORSEY | ||||
9 | ALEE | AGONZALEZ | BMINOTT | ||||
10 | BAMANTE | BMINOTT | |||||
Sheet1 |
I've tried to use the UNIQUE function to identify unique entries and the SORT function to put them in order, but I can't seem to find a way to combine the functions to have them work from both lists.
Is there a way to accomplish what I'm trying to do with formulas?
Thanks!