Restrict Duplicates using Data Validation

[Hardeep Kanwar]

How Can i Restrict Duplicates using Data Validation

Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show
me the Error Message


Thanks in Advance

Hardeep kanwar

 

[FARAZ QURESHI]

Send me your email address if you want a sample file.
By the way what version are using?

 

[Hardeep Kanwar]

Sorry Sir

MY Mistake

Ifs Working

Thanks and sorry

 

[Hardeep Kanwar]

sure

(e-mail address removed)

Actually few days back in a Interview This Question was asked to Me. And
that time i have no idea about DATA VALIDATION.

Could you Pls send me the File Having Some Example of Data Validation with
there uses.


Thanks Again

 

[Jacob Skaria]

Hardeep, for more on data validation refer the below thread.

http://www.contextures.com/xlDataVal01.html

If this post helps click Yes