Filter as you type for two words

[Kw9213]

Hi Everyone!

I have been using Chandoo's filter as you type directions for awhile and love it. https://chandoo.org/wp/2015/08/22/filter-as-you-type-excel/

However, I was wondering if I can do the same thing for two words the way his code is formatted. It would be searching the same column, but for two words instead of one.

I tried to make two versions of the filter as you type code so people would have to enter two keywords, but that didn't work.

Any help would be appreciated!

 

[Deepak]

I don't understand the issue behind the two words.Pls share a sample file.

 

[Kw9213]

Hi! We are having people search through a database and I used the link above to help them search for a key word.

I was asked if there could be a way to have them search for two words at the same time. Like a filter to look for both youth and program for example.

I have attached the database.

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[chirayu]

attached. check sheet 7 for macro