formulas for data validation

L

Luke

Hi

I want to create a formula for a data validation.

I must not be able to enter a “ticket number†that already exists in my
database in a specific column.

Regards,

Luke
 
B

Bob Phillips

=COUNTIF(A:A,A2)=0

where a2 is the DV cell

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
T

Toppers

=COUNTIF(A:A,A1)<=1

Bob Phillips said:
=COUNTIF(A:A,A2)=0

where a2 is the DV cell

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
B

Bob Phillips

oops! I think I was thinking of comparing back up.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top