Allow (validation) except
 

Hey, all. I want to allow all users to enter account numbers into an excel
log, except for "do not quote" account numbers, but I can't figure out how to
do it. Is there a way to allow anything except a few account numbers.

Thanks.

List the "do not quote" account numbers on a worksheet. In this example
they're in cells A1:A10

Select the cell in which you want data validation
(cell D3 in this example)
Choose DataValidation
From the Allow dropdown, choose Custom
In the Formula box, type the formula:

=COUNTIF($A$1:$A$10,D3)=0

Click OK

mfebinger wrote:
Hey, all. I want to allow all users to enter account numbers into an excel
log, except for "do not quote" account numbers, but I can't figure out how to
do it. Is there a way to allow anything except a few account numbers.

Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html