use Text Filters with a selected value

[zzliang]

hi all,

i want to filter all "system" contains "AAA" and list them separately. i use FILTER function but only "AAA" can be filter, how can i make "AAA,BBB" also be filter?

[#2 · Accepted solution]

Hi @zzliang 

There are many ways to construct the formula, you can try below formula 

=FILTER($A$2:$C$6,ISNUMBER(FIND(E2,A2:A6)),"No Data found")

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

 

[#3]

@Faraz Shaikh it works, thank you!