Hello all,
I am new in this forum, but I hope there's someone who can help me.
I am trying to conduct a search engine in excel, to retrieve entries containing the words in my search box. I managed to build a search box to type in words and show the entries which contain the words. The use of wildcards (*) is possible as well.
But what I did not manage and could not find any help searching the internet is, to find entries which contain the words in my search box but in a different order.
For example if I have the entries: "I need help" and "help is needed" and I type in my search box "help*need" that both entries containing the words are shown. In my case, only the second entry "help is needed" is display.
Is this possible and could please anybody help my?
I upload an example excel sheet with my search function, my search box is yellow.
Thanks a lot in advance!!
If you need any further information, just tell me.
Bookmarks