use Text Filters with a selected value

New Contributor

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 Replies
Best Response confirmed by zzliang (New Contributor)

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


@Faraz Shaikh it works, thank you!