I want a formula in column C to return a list, with any duplicates removed, of the values in column A that do not exist in column B.

I'm using UNIQUE to get the unique values in column A, but can't work out how to remove the values that also exist in column B.

Does anyone know the answer?


2 Answers 2


you can try this:


enter image description here


You can try something like this too:

=UNIQUE(QUERY(A2:B;"select A where not A matches '"&TEXTJOIN("|";1;B2:B)&"'";0))

or US notation:

=UNIQUE(QUERY(A2:B,"select A where not A matches '"&TEXTJOIN("|",1,B2:B)&"'",0))

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.