Sort and filter function

[BORUCH]

hi
i have the below formula for some reason the second filter is not working (D3:D56777=V1) can someone explain why

=SORT(FILTER(B3:B56777,(C3:C56777=U1)*ISNUMBER(SEARCH(T1,B3:B56777)),SORT(FILTER(B3:B56777,(D3:D56777=V1)*ISNUMBER(SEARCH(T1,B3:B56777)),SORT(FILTER(B3:B56777,ISNUMBER(SEARCH(T1,B3:B56777)),"No Match Found"),)),)))

 

[Fluff]

Ok, how about

=LET(Rng, B3:B56777,Rws,SEQUENCE(ROWS(Rng)),SORT(FILTER(Rng,(IF(U1<>"",(C3:C56777=U1),Rws))*(IF(T1<>"",ISNUMBER(SEARCH(T1,Rng)),Rws))*(IF(V1<>"",D3:D56777=V1,Rws)*(Rng<>"")),"No Match Found")))

 

[BORUCH]

Ok, how about

=LET(Rng, B3:B56777,Rws,SEQUENCE(ROWS(Rng)),SORT(FILTER(Rng,(IF(U1<>"",(C3:C56777=U1),Rws))*(IF(T1<>"",ISNUMBER(SEARCH(T1,Rng)),Rws))*(IF(V1<>"",D3:D56777=V1,Rws)*(Rng<>"")),"No Match Found")))

thanks that worked
i would just need to modify it if i want to bring back the customer number in the next column it seems to be making problems when i change B3:B56777 TO A3:A56777 It says no match found if i put lets say the word super

=LET(Rng, A3:A56777,Rws,SEQUENCE(ROWS(Rng)),SORT(FILTER(Rng,(IF(U1<>"",(C3:C56777=U1),Rws))*(IF(T1<>"",ISNUMBER(SEARCH(T1,Rng)),Rws))*(IF(V1<>"",D3:D56777=V1,Rws)*(Rng<>"")),"No Match Found"))

)

 

[Fluff]

If you still want to filter col B based on T1 you will need to change

ISNUMBER(SEARCH(T1,Rng))

to

ISNUMBER(SEARCH(T1,B3:B56777))

 

[BORUCH]

If you still want to filter col B based on T1 you will need to change

ISNUMBER(SEARCH(T1,Rng))

to

ISNUMBER(SEARCH(T1,B3:B56777))

thanks a million works perfectly

 

[Fluff]

You're welcome & thanks for the feedback.

 

[BORUCH]

You're welcome & thanks for the feedback.

hi

I'm wondering if its possible with your formula to automatically add a grand total at the end of the list and it automatically subtotals all columns to the right ?

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks