Thread: Restrict Duplicates using Data Validation
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Hardeep kanwar Hardeep kanwar is offline
external usenet poster
  
Posts: 65
Default Restrict Duplicates using Data Validation
sure



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

"FARAZ QURESHI" wrote:

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
Reply With QuoteReply With Quote