For intersection you can use the following formula if your excel supports LET command. =LET(x,ISNA(MATCH(G29:G34,H29:H32,0)),IFERROR( FILTER(G29:G34,NOT(x)),"")) G29:G34 is the range of first set H29:H32 is the range of second set