![]() |
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? |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com