PDA

View Full Version : Solved: Restrict specific words from a column



valendj
08-16-2010, 07:55 AM
I have people putting in their department instead of their name in a column “Requested by” I want to restrict “Accounting”, “Purchasing” and “Quality” from being used in the column. I am new at this and I not sure how to do this any help would be great. Thanks in advance!

Bob Phillips
08-16-2010, 09:20 AM
Try using Data Validation with a type of Custom and a formula of

=AND(A2<>"Accounting", A2<>"Purchasing",A2<>"Quality")

or better still create a list of allowable values and use that in DV.

valendj
08-16-2010, 05:25 PM
Thanks Again!