On Fri, 13 Jul 2007 20:02:59 -0400
Peter Abbott wrote:
> 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?
>
Filters are a sort of restricted IF statement with a particular purpose.
The IF formula is therefore more powerful as you control the purpose.
--
Michael
Linux: The OS people choose without $200,000,000 of persuasion.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
