Hi Shane

its doesn't seem to work when I test it


--
HTH

Pls provide your feedback by clicking the YES button below if this posting
is helpful
This will help others to search the results in the archive better

cheers, francis


"Shane Devenshire" wrote in
message ...
Hi,

Choose Data, Validation, Custom and enter the following formula

=AND(B1<A:A)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dias" wrote:

Hello!
I am looking for a formula that prevents the entry of duplicates.
Not insert a value in cell B1 when the value already exists in column A.
Any idea?
Thanks