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

To pinpoint duplicate entries, apply Excel's conditional formatting feature: Open the Excel worksheet containing the data in question. Select the column or range you want to inspect for duplicates.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.