Use the Data Validation + Countif function. It Prevents the user from entering Duplicate data.

To do this:

1. Select a range of cells, for example, A2:A20.

2. On the Ribbon click <Data> à <Data Validation>

3. Select the [Settings] tab.

4. From the Allow dropdown list, select Custom.

5. In the Formula box, enter the following formula:

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

6. Type an appropriate error message in the [Error Alert] Tab

More Under Finance

0 Comments

  1. Brij Mohan says:

    Prevent duplicates entry data fomula/excel tips is very useful and other excel tips is also very useful for me.

    Thanks/Regards Brijmohan

Leave a Comment

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

Search Posts by Date

September 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930