07-06-2020 12:53 AM
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?
07-06-2020 01:36 AM - edited 07-06-2020 01:37 AM
SolutionHi @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