Bookmarked Sheets Tip 322: Comparing two columns (ckarchive.com)
@media only screen { .email * { word-break: break-word; } } @media screen and (max-width: 384px) { .mail-message-content { width: 414px !important; } } @media only screen { .ema...
This is where the magical FILTER function really shines. It will take the array inputs and give us array outputs, without needing an array formula designation.
Add in the ​FILTER function​ so that our formula in cell B2 looks like this:
=FILTER(A2:A,ISNA(XMATCH(A2:A,D2:D)))And voilĂ !
Source: Comparing Two Columns by Ben Collins
—
I have never looked at XMATCH. Another one to explore.
The post đź“‘ Sheets Tip 322: Comparing two columns first appeared on Read Write Collect.