1
I have got two different spreadsheets with some duplicate emails in it but maybe with different information in other cells of the same line. Both of the spreadsheets contain more than 10k lines. I succeeded in filtering out the duplicates by extracting the relevant data in a separate spreadsheet but i do not know how to delete the whole corresponding line of one of my original spreadsheets
spreadsheet. as an example:
spreadsheet 1:
1 a b@gmail.com
2 c d@gmail.com
3 f e@gmail.com
spreadsheet 2:
1 b a@gmail.com
2 f d@gmail.com
3 c e@gmail.com
then spreadsheet 2 should remain:
1 b a@gmail.com
But where are the Duplicate Mail IDs ? All six are unique !! – Rajesh S – 2018-02-20T12:15:13.380