Custom Function for OR Function to Test for more than 50 items?
Posted on 2012-08-15
I am trying to create a formula to check a column of entries to make sure the entries are either a 2 digit state or the word "foreign". I am thinking about using the OR function and tagging the items as error if they don't meet any of the items. The problem is that these entries are copied and pasted from elsewhere so validation is out. The entries could also have extra spaces which is not so evident, but would cause a problem because this data is used in pivot tables.
Can I create a custom function for this or use some kind of list of data in the OR Function?