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

"Mike" wrote:

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")

"David" wrote:

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.