Anthony Chilco keyed the following on 7/13/2007 5:26 PM:
Hi Peter,
The most straightforward way to do what you want is to open the csv file
and import all of it. Fill an empty column with the formula
=IF(AND(ISERROR(FIND("msn.com";A1));ISERROR(FIND("hotmail.com";A1)));"NOT";"Flag")
This is assuming that the addresses are in column A. Adjust the formula
if they're not. If you paste the formula above into the top cell of your
empty column, then fill down, you'll have 'Flag' or 'NOT' in each cell.
Sort the entire sheet by that column and delete the rows that you don't
want.
Thanks. I guess that filters cannot be used for this?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
