| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List item Based on Cell value
Hi All,
I have a data validation list in a cell having more than 500 items. is it possible to have selected items to show on the drop down list based on the first letter/letters i enter in the cell? My list is already sorted alphabatically. like if i type M in my cell the dropdown list show only items starting M and in case i enter ME all items startinf ME and like wise..? TIA Soniya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
| Attaching a 2 item list to a cell / drop-down? | Excel Discussion (Misc queries) | |||
| cell reference to last item in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
