With Excel 2016, Duplicates can be removed quite easily. Just select any row in the table . Then activate the data tab in the ribbon menu and click on the Remove Duplicates option in the Menu. And then select the columns where Duplicates should be removed. Once you do that, it would give you a notification as to the number of Duplicates removed and the number of remaining rows in the table.