Skip to content

Instantly share code, notes, and snippets.

@davecurrierseo
davecurrierseo / Compare Columns
Last active July 7, 2022 17:46
Google Sheets Cheat Sheet
# Compares Columns A and B by outputting values that are found in column A but NOT B.
Useful for checking a full site crawl against a sitemap.
=FILTER(A2:A,ISNA(MATCH(A2:A,B2:B,0)))