Here is my scenario. I'm have a list of products that are in varying sizes.
Now all of the sizes fall into a certain range, but not all of the products
come in the same sizes.
Example: Product X is available in sizes 1, 2, 4, and 5, but product Y only
has 2, 3, and 5.
Is there a way to create a drop down list (or similar, wanting to keep it in
one cell if possilbe) that uses a range containing 1 - 5, but exclude
certain values.

Please refer

http://www.contextures.com/xlDataVal13.html
--
If this post helps click Yes
---------------
Jacob Skaria


"Joe" wrote:

Here is my scenario. I'm have a list of products that are in varying sizes.
Now all of the sizes fall into a certain range, but not all of the products
come in the same sizes.
Example: Product X is available in sizes 1, 2, 4, and 5, but product Y only
has 2, 3, and 5.
Is there a way to create a drop down list (or similar, wanting to keep it in
one cell if possilbe) that uses a range containing 1 - 5, but exclude
certain values.