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.