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.

  • Did you try something like a =counta() to check duplicates then use a =filter() ? – pjmg Apr 12 '20 at 7:19
  • Thanks, I'm not sure how I would use COUNTA or FILTER in this case. I was trying to use something like: =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:01
  • I ended up using something like this: ArrayFormula(FILTER(A2:A,ISERROR(match(A2:A,B2:B,0)))) – Skeletor Apr 14 '20 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.