Tips & Tricks 208 – Present in A but not in B

To find if an entry is present in one column but not in another

=UNIQUE(VSTACK(A2:A9,B2:B9,B2:B9),,1)

=FILTER(A2:A9, ISERROR(XMATCH(A2:A9,B2:B9)))

=FILTER(A2:A9, COUNTIF(B2:B9,A2:A9)=0)

Sample File – T&T_208