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

"Hardeep Kanwar" wrote:

Thanx for Quick Reply

But its not Working



"FARAZ QURESHI" wrote:

Select A1
In Data Validation select Custom
Insert the following formula
=NOT(COUNTIF(A1:A$1,A1)1)
Copy down the cell.

"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