Limited Data Validation

[gilbert]

Hi hi..

In Data Validation, can we allow people to key in only certain numbe
which is not in series... eg. 30, 40, 50, 60... In another word, th
user could just key in these number, they cannot key in 31, 32, 55 o
even other numbers or alphabets.

I know we can do it by way of Data Validation - List but is there an
other way we could go about it if we don't want to use listing instea
we want people to key in themselve?

Please share your thoughts.:rolleyes

 

[Biff]

Hi Gilbert,

I'm kinda partial to the point and click ease of a
dropdown, but here's how to do it:

In Data Validation select Custom.
In the formula box enter something like this:

=OR(A1=30,A1=40,A1=50,A1=60)

Biff