SV650.org - SV650 & Gladius 650 Forum - View Single Post - Deleting duplicate email addresses from a database

21-08-09, 02:12 PM

Ah, the MS office solution:

If you've opened them in Excel and are having a can't be *rsed Friday afternoon (and can reimport back to the db) assuming you don't want to use SQL:

Make column A the values from the 15K rows
Make column B the formula =MATCH(A1,C:C,0)
Make column C the 3K unsubscribed peoples emails.

Copy and paste row B down to as many rows as column C has

On any row the number displayed in column B indicates on which row that email address is found in column A, if it is found - therefore, convert all formulas to their text results, replace all blanks in column B with zeroes , sort the range A,B,C by column B and the values that are >=1 are the matches where an unsubscribed email is in the 15K list - delete them and reimport.

Failing that, write the lot in Lotus Notes and be done with it!

21-08-09, 02:12 PM	#3
ooger Guest Posts: n/a	Re: Deleting duplicate email addresses from a database Ah, the MS office solution: If you've opened them in Excel and are having a can't be *rsed Friday afternoon (and can reimport back to the db) assuming you don't want to use SQL: Make column A the values from the 15K rows Make column B the formula =MATCH(A1,C:C,0) Make column C the 3K unsubscribed peoples emails. Copy and paste row B down to as many rows as column C has On any row the number displayed in column B indicates on which row that email address is found in column A, if it is found - therefore, convert all formulas to their text results, replace all blanks in column B with zeroes , sort the range A,B,C by column B and the values that are >=1 are the matches where an unsubscribed email is in the 15K list - delete them and reimport. Failing that, write the lot in Lotus Notes and be done with it!