Comparison of accounts in Excel windows 7 between two different sheets and combining in one list
Solution 1:
Depending on how often you are doing this, and how much work is involved, you could just copy each set of data and paste them underneath each other to create a big list, full of duplicates as well.
Then, click on Data tab, highlight the entire list and select Remove Duplicates. Then, with the list still highlighted, sort it (see image below)
Please note, this should also work where you have data in multiple columns (in most cases)