Create unique list of items from 2 different lists in Excel

00:00 Remove duplicates where multiple but not all columns indicate duplicate
00:15 Use the Remove Duplicate Tool
00:35 Remove the column that does not need to be the same

Use the Remove Duplicates tool to find the unique values between 2 lists that should have been the same but for some reason there are differences between the 2 lists.