@carlwummel9050

Excel is just sooo intuitive

@inkuban

"ISNUMBER()" because the inner function "SEARCH()" returns the index number for the word. Therefore, when the search function returns the index number, the "ISNUMBER" will return "TRUE", and the "FILTER()" function will return the value for all the 'true's.  TRUE() function could have been used instead of "ISNUMBER()" but it wouldn't be safe because sometimes anomalies could return as true.

@chrism9037

Thanks Leila, I wouldn’t have thought of this approach. The ISNUMBER isn’t intuitive in this situation, but it obviously works!

@sameh1180

You are a legend of Excel

@gynoval

LEILA IS THE LEGEND. WAS LOOKING AROUND FOR THIS ANSWER!!

@YoucefYoucef-ft9ce

Thank you for all your efforts teacher Leila from the US

@prosimulate

New skills are gold! Thanks a million!

@ccuny1

That's very useful. Thank you Leila. It would be great if Excel included Tags by default. I am sure there are ways of achieving something similar though and this video is a step in the right direction for me.

@SyafiqMedia1

Thanks, brilliant..

@nathanthayan2517

Clever solution!

@umairanwar6719

super works like a charm

@sachinrv1

Wow Leila. I am amazed to see how old excel formulas and so easily integrated with new excel i.e office 365

@borstenpinsel

It's really not the wrong approach when countif and sumif work fine with "*". It's MS's inability to create a coherent product, probably because filter() was written by people who have never really used excel. Thanks for the tip anyway. MS is the enabler of gate keeping. Even though there are now tons of free tutorials l, of which we have another stellar example here, Excel is far from simple ad intuitive to use for most people.

@stanTrX

Its a good workaround.obviously difficult to guess :)

@shanestocks89

Thanks, trying to understand why ISNUMBER works...

@MasterBrain182

Astonishing content Leila 💯💯💯 Thanks to share your knowledge with us 👍

@josephdaquila2479

I wrote a custom function recently called contains that basically nests search and isnumber together. I feel like the word contains is a very natural language way to say what you want it to do. 

Just takes a couple of lines in VBA.

@flourishwithMJ

Thank you.❤

@Yokenshiro11

love it this will be my new search function from now on, i just switch the key word for search with a cell search box for custom entries, and fuse the 2 column of the array into one so i can search in both of them at the same time while returning both the column results, works like a charm for names + first names researches, and i can even hide the fused column for estetic and avoid repetition

@HarpreetSingh1991

This is magic. What should I do to be like this genius who can figure it out myself like a combination of functions