How To Prevent Duplicate Entries In Excel

Prevent Duplicate Entries In Excel

This Example teaches you how to use data validation to prevent from duplicate entries in Excel.

How to Find Duplicate Values in Excel

1) Select data which you want to prevent from duplicate entries.

2) Select Data Validation option from Data Tab in Menu bar.

3) In Validation Criteria section Select "Custom Rule"

4) Type the below formula in the Formula bar

     =COUNTIF($A$2:$A$10,A2)=1

        Here i was selected A2:A10

5) If you enter any existed value it will restrict you with the warning window.

Google Search Console or Webmaster Tools For Blog