It should have worked if the email addresses match.
Try this heavier duty formula ..
In Sheet1,
Put instead in X2:
=IF(C2="","",IF(SUMPRODUCT(--ISNUMBER(SEARCH(C2,Sheet2!$A$1:$A$80)))0,"x",""))
Copy down. Then autofilter for "x" in col X, delete these rows.
If the above still doesn't do it, post some samples of the email addresses
in Sheet1's col C and the bounced ones in Sheet2's col A.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
Thank you Max,
After I copy and pasted, all cells returned FALSE - no tru values at all.
Any suggestions?
Mark