SOLVED

use Text Filters with a selected value

Highlighted
New Contributor

hi all,

 

12.png

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

 

 

Snag_24073905.png

 

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

 

Highlighted

@Faraz Shaikh it works, thank you!