Use a non-contiguous range of numbers for data validation

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

Is it possible to use a non-contiguous range of numbers with Excel's built-in data validation, or is
this something else that needs to go in the Worksheet_Change event?

TIA,

Rick
 
Rick
Your question doesn't make any sense as stated. What do you want to do?
HTH Otto
Rick B said:
Is it possible to use a non-contiguous range of numbers with Excel's
Click to expand...
built-in data validation, or is
 
Are they each a static list?

If yes, then give each a name (insert|name|define).

I chose Name1 and Name2.

Then in another column, select a range with the same number of rows as Name1.
type =name1 (and hit ctrl-shift-enter)

Right underneath that range, do the same thing with Name2

Then use that new big range for your data|validation list.

Debra Dalgleish has lots of techniques for working with Data|validation at:
http://www.contextures.com/xlDataVal01.html
 
Dave said:
Are they each a static list?

If yes, then give each a name (insert|name|define).

I chose Name1 and Name2.

Then in another column, select a range with the same number of rows as Name1.
type =name1 (and hit ctrl-shift-enter)

Right underneath that range, do the same thing with Name2

Then use that new big range for your data|validation list.

Debra Dalgleish has lots of techniques for working with Data|validation at:
http://www.contextures.com/xlDataVal01.html
Click to expand...
For instance validate if values are 1,3,6,8,9,10,15.

Rick B
 
You can list the valid numbers on a worksheet, and name the range of
cells. Then, in data validation, either use the list or a custom formula--

Allow: List
Source: =NumList

or

Allow: Custom
Formula: =COUNTIF(NumList,D3)

where D3 is the cell in which data validation is being applied.
 
Back
Top