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