I have thousands of data in 2 columns

First one is ordered by export and the other by latest activity. The export columns has more queries than the latest activity. (can't change the export to the latest activity)

I stuck in finding a way to get all the email addresses from the latest activity and check where they are in the export list. And important sidenote: the latest activity list is incomplete at the end of each query. As the example below.

[email protected]  [email protected]
[email protected]  [email protected]
[email protected]  name6
[email protected]  name1@ma
[email protected]  [email protected]
[email protected]  name2@ma
[email protected] 
[email protected]

I need to find and keep all the duplicates and remove all the others So in this case [email protected] & [email protected] should be deleted.

Is this something I can do in Sheets automated instead of manually finding each one by cmd+f.

I have about 5000 active users I need to filter out. fingerscrossed

The expected result would be that I can exclude everything from the first column based on everything from the second column.

Link for example:


  • Welcome. What would the expected results be in your example? Also. Is the question about Excel or Google sheets? Please edit your question. Feb 24, 2021 at 10:58
  • "...exclude everything from the first column based on everything from the second column" Sorry but it does not make sense. Please read how to and share a test sheet so as you can be easier helped. Feb 24, 2021 at 11:02
  • The only "duplicate" in both your sheet as well as your example is [email protected]. Is this what you want? BTW, your sheet does not help much :( Feb 24, 2021 at 13:27
  • I found the solution with google-apps-script here > stackoverflow.com/questions/33682318/… Feb 24, 2021 at 13:31

1 Answer 1


Solution to my problem and maybe the viewers problem can be fixed with this: https://stackoverflow.com/questions/33682318/copy-row-to-new-sheet-using-google-apps-script

  • While links might be helpful, answers should be self-contained. Please consider adding the relevant parts or a summary of the linked resource. P.S. This question was bumped by Community a few moments ago. It has been bumped by Community 8 times. Jul 15, 2023 at 0:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.