You have the option to alphabetize the data in Excel, filter the entries, remove duplicate and blank ... the value isn't in the second column. Match The Two Columns Row-By-Row With Comparison ...

1. Click "Data" in the top menu of the Excel window to open the Data menu ribbon. 2. Click on "Remove Duplicates." 3. A window will pop up. If your column includes a header, make sure the box next ...