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.
firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org name6 email@example.com name1@ma firstname.lastname@example.org email@example.com firstname.lastname@example.org name2@ma email@example.com firstname.lastname@example.org
I need to find and keep all the duplicates and remove all the others So in this case email@example.com & firstname.lastname@example.org should be deleted.
Is this something I can do in Sheets automated instead of manually finding each one by
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: