filter function twice

[BORUCH]

hi
i have the below formula

=SORT(FILTER(A3:A56777,ISNUMBER(SEARCH(R1,B3:B56777)),"No Match Found"))

my question is i want to add another filter in the same formula how do i go about that

my other filter would look something like this

=SORT(FILTER(A3:A56777,ISNUMBER(SEARCH(S1,C3:C56777)),"No Match Found"))

how do i combine them to one formula to give me my final results

Thanks

 

[Fluff]

How about

=SORT(FILTER(A3:A56777,(ISNUMBER(SEARCH(R1,B3:B56777)))+(ISNUMBER(SEARCH(S1,C3:C56777))),"No Match Found"))

 

[BORUCH]

How about

=SORT(FILTER(A3:A56777,(ISNUMBER(SEARCH(R1,B3:B56777)))+(ISNUMBER(SEARCH(S1,C3:C56777))),"No Match Found"))

sorry my question is a little different
i would like to add a filter not use the “ is number” formula on the second filter the second filter would be just filter A3:A56777 the criteria is C3:C56777=S1

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

In that case how about

=SORT(FILTER(A3:A56777,(ISNUMBER(SEARCH(R1,B3:B56777)))+(C3:C56777=S1),"No Match Found"))

 

[BORUCH]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

In that case how about

=SORT(FILTER(A3:A56777,(ISNUMBER(SEARCH(R1,B3:B56777)))+(C3:C56777=S1),"No Match Found"))

thanks that worked

 

[Fluff]

You're welcome & thanks for the feedback.