How to prevent Duplicate Email and Phone Entries in Excel

How to prevent Duplicate Email and Phone Entries in Excel

Αποφυγή διπλότυπων καταχωρήσεων ηλεκτρονικών διευθύνσεων αλληλογραφίας και τηλεφώνων

Step 1

Mark All Email Cells except title. Do that before any data entry.

Go To Data > Data Validation > Settings > Custom

and type =COUNTIF($D$4:$D$303;D4)=1

Then go to “Error Alert” Tab and choose

Style : Stop

Title : Duplicate Email Found

Error message : Email cannot be duplicated.

Step 2

Mark All Phone Cells except title. Do that before any data entry.

Go To Data > Data Validation > Settings > Custom

and type =COUNTIF($E$4:$E$303;E4)=1

Then go to “Error Alert” Tab and choose

Style : Stop

Title : Duplicate Phone Found

Error message : Phone cannot be duplicated.

YouTube link: https://youtu.be/7S3iAqiwhHs

Filename: form_VBA_2_prevent_duplicates_2.xlsb

Download zip file of excel file

#excel_tips #softexperia