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!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.