| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation List created from a text in a Cell
Hello,
Whats the simplest way to create a data validation list from a comma separated text present in another cell? The text in this cell is dynamic and keeps changing. I can think of breaking the text by using MID, FIND, IF into multiple cells and then using the multiple cells as source to the Data Validation. Any cool hacks? Thanks you. Gap |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| BUG? : data validation in-cell drop down list is not displaying | Excel Discussion (Misc queries) | |||
| How do you create a list & data validation in same cell? | Excel Worksheet Functions | |||
| Can you create a LIST and DATA VALIDATION CRITERIA in same cell? | Excel Discussion (Misc queries) | |||
| Validation function that created from another drop down list | Excel Discussion (Misc queries) | |||
| data validation list drop down text format too small | Excel Worksheet Functions | |||
Threaded Mode
