Data Validation with multiple conditions

[Serjape]

I am needing to us data validation to exclude certain data being entered into cell such as " no ticket", "see ticket", "na", "N/A", etc .... I am trying to get users to enter ticket number and not be lazy

 

[kevin9999]

Is the Ticket Number always an integer (no letters, spaces etc.) and if so, what are the lowest & highest possible numbers?

 

[Serjape]

The ticket number is always letter and numbers but never any spaces. I was trying to figure a way to accept anything BUT a certain list....

 

[Serjape]

Is the Ticket Number always an integer (no letters, spaces etc.) and if so, what are the lowest & highest possible numbers?

An example would be INC0002341 or SOPN23145

 

[kevin9999]

Thank you for the examples. I'm afraid what you require is beyond my level of expertise, but hopefully someone else on this forum will be able to assist.

 

[Serjape]

Thanks Kevin.

It's basically data validation with multiple arguments for cell. Anyone?

 

[Akuini]

I was trying to figure a way to accept anything BUT a certain list....

Try:
Goto Data > Validation
Allow: Custom
Formula:

=AND(A1<>{"no ticket", "see ticket", "na", "N/A"})

Another way:
you can put the list on a range then create a named range (refer to the range) then use the name in the formula.
Say the named range is "Exclude" then formula in data validation:

=AND(A1<>Exclude)