Generating random lists of numbers in Excel is handy for randomizing ... it will be quicker to select the whole column instead. Then, in the Data tab, click "Remove Duplicates." ...