So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

Excel will eliminate duplicate entries, leaving unique values. This method might remove duplicates in your data that you'd like to keep, so if this happens, consider manually deleting the data ...

When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe. 1. Click "Data" in the top menu of the Excel window ...