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

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

If this post helps click Yes
---------------
Jacob Skaria


"Hardeep Kanwar" wrote:

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