[QUOTE=ooger;2011808]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:
QUOTE]
Ooger thanks for this, you must know my Friday afternoon antics.
Defo, especially after 2hrs of Friday lunchtime watering hole ventures
Anyway, managed to the numbered results in column B but a few are reporting back as #N/A is this correct? or does this mean no matches found.
Now need to do the following but not sure how to:
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