So, to fix the random numbers you generated ... In my case, my data is in column E and doesn't have headers, so I'm good to click "OK." Excel then tells you how many duplicates it has removed.