formulas for data validation
 

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

formulas for data validation
 

=COUNTIF(A:A,A2)=0

where a2 is the DV cell

--
HTH

Bob Phillips

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

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

formulas for data validation
 

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

"Bob Phillips" wrote:

=COUNTIF(A:A,A2)=0

where a2 is the DV cell

--
HTH

Bob Phillips

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

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

formulas for data validation
 

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

--
HTH

Bob Phillips

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

"Toppers" wrote in message
...
=COUNTIF(A:A,A1)<=1

"Bob Phillips" wrote:

=COUNTIF(A:A,A2)=0

where a2 is the DV cell

--
HTH

Bob Phillips

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

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