Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Data Validation Multiple Select List?
justice,
You can only enter items from the list. If there are combinations, then you would need to have those combinations already in the list. As an alternative, you could use multiple validated cells and concatenate the values using a formula in a non-validated cell. HTH, Bernie Excel MVP "justice" wrote in message ... Please help with this problem. I have a column range set for data validation and I am using the List. I need to have multiple items from the list input in various cells. My list will only allow one selection per cell. How do I get an entry of multiple selections from the list that are input in the cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a Data validation list to select another validation l | New Users to Excel | |||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
Data validation, select from list: omit blanks? | Excel Discussion (Misc queries) | |||
Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) |