Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet.

However, our aim here is to remove duplicates from an already-created list of random numbers. Also, combining those functions is far more complicated than the simple steps I'm about to show you.

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.