I want to build a function that will return all of the email addresses from column D in one Google Spreadsheet that are not present in column D of a different Google Spreadsheet.
This could be in the form of a function that runs automatically once a day, or it could just be manually refreshed- either way is fine.
Email addresses will not correspond to the same row in each sheet, the columns in each sheet are populated from two completely different forms. So I need to compare both entire columns, and spit out the email addresses from Spreadsheet1 column D that aren't in column D of Spreadsheet2.
=counta()
to check duplicates then use a=filter()
? – pjmg Apr 12 '20 at 7:19=ARRAYFORMULA(IFERROR(VLOOKUP('Spread Sheet 1'!D2:D, 'Spread Sheet 2'!D2:D, 1, False)))
But I don't really know what I'm doing with that. – Skeletor Apr 13 '20 at 17:01ArrayFormula(FILTER(A2:A,ISERROR(match(A2:A,B2:B,0))))
– Skeletor Apr 14 '20 at 16:12