Filtering Multiple Text Strings in Column

[buimichael]

I would like to filter out the items that contain WLM or CLOUD in the following chart and display only the rows that contain these.

Any function that can filter out this text?

Thanks.

[Eastw00d]

You can use a standard filter using ?L* since L is what cloud and wlm have L in common as second letter.

Cheers
Erwin

[loginjmor]

You could use the following array formula that finds if each string contains either WLM or CLOUD and then creates an array of valid row numbers. Using SMALL floats the valid row numbers to the top and the invalid rows to the bottom, and then simply use INDEX to spit out what is contained in each valid row.

=IFERROR(INDEX($A$2:$A$6,SMALL(IF(ISERROR(IFERROR(FIND("WLM",$A$2:$A$6),FIND("CLOUD",$A$2:$A$6))),"",ROW($A$2:$A$6)-1),ROW()-1)),"")

As this is an array function, you have to press Ctrl-Shift-Enter to engage that functionality (you can google how to do this).

I have attached a sample spreadsheet.

Hope this helps.