SOLVED

use Text Filters with a selected value

%3CLINGO-SUB%20id%3D%22lingo-sub-1505035%22%20slang%3D%22en-US%22%3Euse%20Text%20Filters%20with%20a%20selected%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505035%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2212.png%22%20style%3D%22width%3A%20450px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203449i2803D0D1E5169318%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%2212.png%22%20alt%3D%2212.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ei%20want%20to%20filter%20all%20%22system%22%20contains%20%22AAA%22%20and%20list%20them%20separately.%20i%20use%20FILTER%20function%20but%20only%20%22AAA%22%20can%20be%20filter%2C%20how%20can%20i%20make%20%22AAA%2CBBB%22%20also%20be%20filter%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505035%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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
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

 

@Faraz Shaikh it works, thank you!