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?
View best response
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!