This video tutorial covers how to compare two worksheets for matches or duplicates with no unique ids in Excel. It also covers how to merge two lists to one master list with no duplicates.

Download Excel Power Query for 2010 & 2013 versions here https://www.microsoft.com/en-us/download/details.aspx?id=39379