Please help me in extracting values from the given text description and please create a searchable drop down list for the example given in attachment, please refer to the attachment and please do the needful.
Text extraction and searchable data validation list
A formula to extract the FFID & Job ID are:
=MID(B3,FIND("Job ID",B3, 1)+8,10)
I cannot determine what you are asking for with respect to a "searchable drop down list for the one below" sorry.
Thanks for replying and please check the sheet2 in this attachment.
In column A having languages has to be entered through drop down but if I want to choose "Turkish" from drop down I need to scroll down until "T" letter comes, is there any possibility to search with letters and shows the match cases in the drop down list. Like if enter "T" it shows all languages having T
please find the attachment and please do the needful...
Not sure if this achieves what you are after, I do not know another way to do it without using VBA macros.
remove the data validation you have and in A2 type:
in B2 type:
then type what you want to search for in B1.
This requires a new version of excel with spilling formulas, sorry if you do not have it.
Thanks for reply am using ms office 2016, filter function is not available....
Thank you so much or else is it possible through VBA..
Don’t have an account yet? Register yourself now and be a part of our community!