Excel will then scan the selected columns for duplicates and remove them. When it's done, a dialog box will pop up notifying you how many duplicates were removed and how many unique values were ...