Excel 2007 : Conditional deleting

[CarlBe]

Hi

I have two columns - "A" and "B"
In "A" there is a list of about 2000 emails. In "B" there is a number - either "0" or "1" - that shows whether the EMail has been validated.

Is there any way that I can block remove (other than doing them all individually !!!) all the EMail rows that have a "0" next to them in Column "B" ?

Thanks

Carl

[scaffdog845]

CarlBe

Welcome to the forum. I'm sure one of the Gurus have a cleaner solution but this can easily be done with helper columns.

Assuming you list of Emails starts in column "A" on sheet 1, place the formula

=IF(Sheet1!B1=1,Sheet1!A1,"")

in cel A1 on sheet 2 and copy down to atleast row 2000. Apply a filter to sheet 2 and have it not show the blanks.

I've attached a sample.

[JBeaucaire]

If there are "titles" in row 1 on your original sheet, you can apply an AutoFilter to the original data.

DATA > FILTER > AUTOFILTER

Then use the drop down that appears in column B to filter any way you wish.

[CarlBe]

Hi

Thatīs great - worked perfectly - many thanks

Carl

[williemh]

If you wanted rid of them permanently, why not just sort the 0/1 column numerically then select and delete all the 0s in one go?