Excel 2007 : Conditional deleting

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

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

Please Login or Register  to view this content.

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.

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.