Researchable drop down list

[ranie]

Hi,

As my excel version does not have filter, sort, unique functions I have to use other set of formulas to search the drop down list in data validation.

Column C	Column D
running shoes adidas
cooking salad
eating chocolate cookies
sleeping at friend's house
baking cookies at Julie's house

Column C will contain the list of data
Column D3:D40 will contain the drop down list

let say if i want to search "cookies", the drop down list will show "Eating chocolate cookies" and "Baking cookies at Julie's house"
my current Data Validation formula "OFFSET($C$1,MATCH(D4&"*",C:C,0)-1,,COUNTIF(C:C,D4&"*"),1)


My objective is to make every row of data entry as dynamic search in drop down list data validation such as filtering search without VBA and it will be refresh the drop down list for next row of entry.


Thanks for the help!

 

[Akuini]

without VBA

How about using an add-in?

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com