Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |