How to find duplicate in excel

duplicate excel

  1. Select the range of cells you wish to test. …
  2. On Excel’s Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.
  3. Click OK within the Duplicate Values dialog box to identify the duplicate values.
  4. Duplicate values in the list will now be identified.


duplicate excel


Leave a Reply

Your email address will not be published. Required fields are marked *