 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Use a non-contiguous range of numbers for data validation
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 > 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 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 > 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  SignatureDave Peterson ec35720@msn.com > Are they each a static list? > [quoted text clipped - 18 lines] >> >>Rick 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. >> Are they each a static list? >> [quoted text clipped - 25 lines] > > Rick B SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Sorry, I read it as a non-contiguous RANGE of cells. On top of Debra's suggestion, you could type the values into the Data|Validation dialog (in the source box when List is chosen). > > Are they each a static list? > > [quoted text clipped - 22 lines] > > Rick B SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.