An example would be INC0002341 or SOPN23145Is the Ticket Number always an integer (no letters, spaces etc.) and if so, what are the lowest & highest possible numbers?
I was trying to figure a way to accept anything BUT a certain list....
=AND(A1<>{"no ticket", "see ticket", "na", "N/A"})
=AND(A1<>Exclude)