Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to create a validation rule that goes like this:
(1) Only accept values that start with the value in named cell "Restrict" (2) Do not accept values that contain a "?" (a question mark). Example: If the cell "Restrict" contains "abc", the cell with the validation rule should accept "abc", "abcd", "abc123" etc, but not "abc?", "abcd?", "aab" or anything else. If "Restrict" contains "a", the cell should accept anything starting with "a", unless there's a "?" involved. This should be possible, shouldn't it?? Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions |