Alternatively, select the cells ... so I'm good to click "OK." Excel then tells you how many duplicates it has removed. In my example, 50 appeared in the list three times, and 19 appeared twice ...