Here’s an Excel formula that you can use to compare and remove duplicates from two lists…
Instructions for removing duplicates from your list with Excel:
- Open up Microsoft Excel.
- Paste your entire list into Column A.
- Sort the entire column alphabetically (A > Z). This is very important.
- Click on and highlight Column B.
- With Column B highlighted (press the gray B button above the column to highlight the entire column), enter the following into the “formula” box in Excel.
- After the formula is filled in, and with the entire Column B still selected, go to the menu in Excel, and choose: Edit > Fill > Down.
- This will fill Column B with a new, updated list, with all duplicates removed.
- Now, you’ll want to copy that column into a new spreadsheet. “Copy & Paste” won’t work…
- Select Column B, and choose Edit > Copy.
- Create a new spreadsheet, and select Edit > Paste Special > “Values”.
- Now you should have the final, updated list. You can sort it now, and remove blank lines.
Is the page BLANK? After you paste into a new sheet, blank entries from your list show up at the top, so if you have a very large list, you might have a lot of blank lines near the top. If so, scroll down to see your list.