Duplicated cell

[David]

Hi,

Is it possible to give an error message if you insert a duplicated field in
a excel cell like it can be done in ms access?

Thanks.

 

[David Biddulph]

Data Validation: Formula: COUNTIF(B$1:B1,B1)=1

 

[Mike]

Name a range you want to check, in this case myrange and paste this in

=IF(MAX(COUNTIF(myrange,myrange))>1,"There are duplicates","There are no
duplicates")

 

[Mike]

sorry should have said this is an array formula, Enter with CTRL + Shift +
Enter

 

[Daoud Fakhry]

Hi Mike,
I want to have a field getting inputs and adding it to an excel sheet, as it
is possible in access.

Thanks,
Daoud