How to compare 2 filtered ranges?

[jtm4890]

I have 2 ranges created by Filter command, but how to compare?

E4:E242=SORT(UNIQUE(FILTER($Insumos.$G$4:$G$1353,($Insumos.$E$4:$E$1353="Materiales")*($Insumos.$G$4:$G$1353<>G4:G60),-1)))

G*4:G60=SORT(UNIQUE( FILTER($Insumos.$G$4:$G$1353, (ISNUMBER(SEARCH("PVC",$Insumos.$G$4:$G$1353))+ISNUMBER(SEARCH("EMT",$Insumos.$G$4:$G$1353))+ISNUMBER(SEARCH("TUB",$Insumos.$G$4:$G$1353)))*NOT(ISNUMBER(SEARCH("CANALETA",$Insumos.$G$4:$G$1353))),-1)))

In the formula “G4:G60”, “E4:E242” are Filtered results from a same range, but in the formula “G4:G60” is the result that I need to remove from “E4:E242”,

How do remove results from “G4:G60” in “E4:E242” using formulas?

[Hrbrgr]

Give more Information:

This is the guide - How to use the Ask site?

And your File in original.

[Villeroy]

=ISNUMBER(MATCH(value;other_column;0)) returns True if value occurs in other_column.

[karolus]

=LET( g ; $Insumos.$G$4:$G$1353 ;
 k ;$Insumos.$E$4:$E$1353="Materiales";
 ex; unique( filter(g; (ISNUMBER(SEARCH("PVC";g))+(ISNUMBER(SEARCH("EMT";g))+(ISNUMBER(SEARCH("TUB";g)))*NOT(ISNUMBER(SEARCH("CANALATA";g))); SORT(FILTER(UNIQUE(FILTER(g;k));COUNTIF(g; ex)=0)))

###
=LET( g ; $Insumos.$G$4:$G$1353 ;
 k ;$Insumos.$E$4:$E$1353="Materiales";
 ex; unique( filter( g;ISNUMBER(SEARCH("PVC|EMT|TUB";g))*NOT(ISNUMBER(SEARCH("CANALATA";g))); SORT(FILTER(UNIQUE(FILTER(g;k));COUNTIF(g; ex)=0)))

fix it on your own!