compare 2 range with another 2 range and find unique

[861171314]

Hi Friends
Can you solve this problem for me ?
I need to find unique Item in range1 that have no match in range 2

 

[861171314]

 

[bosco_yip]

In C11, copied down :

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$3:A$7)/(0+ISNUMBER(MATCH(A$3:A$7&B$3:B$7,D$3:D$7&E$3:E$7,0))=0),ROWS($1:1))),"")

Regards
Bosco

 

[861171314]

View attachment 57902

In C11, copied down :

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$3:A$7)/(0+ISNUMBER(MATCH(A$3:A$7&B$3:B$7,D$3:D$7&E$3:E$7,0))=0),ROWS($1:1))),"")

Regards
Bosco

Very Nice
Thank You Very Very Much