Is there any specific function to find unique TP numbers comparing two sheets?-CodePudding

I have two sheets, both of them containing tp numbers, I wanna write a function in which it searches both sheets and finds only unique tp numbers from first sheet that does not exist in the second sheet.

my function, I brought two different tp numbers to one sheet to compare

I tried it by filtering A-z both sheets and if function if they are even write yes and if not write no. But this is really dubious and long. I would like to know if there is any simple way to do this?

CodePudding user response：

=FILTER(G1:G3,ISERROR(XMATCH(G1:G3,J1:J4)))

In your case it's =FILTER(G1:G26,ISERROR(XMATCH(G1:G26,J1:J30)))