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.

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

"David" wrote in message
...
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.

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.

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

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

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.