Delete Row if Cell Blank and also Delete Rows with Same ID as Blank Cell

[genoa]

Hello,
I am trying to delete rows if a cell is blank
and also delete rows with the same ID as
the blank cell.

[zzzeddy]

Hi

In the attached file I added some 'helper' columns to check whether a row should be deleted or not.

The first helper column contains a simple formula that just puts the corresponding ID number in it if the associated Name is blank i.e. this helper column contains all the ID numbers that will be removed.

The second helper column then uses a formula to check whether the ID number in column A is found anywhere in the helper column that contains those ID's that will be removed. We can use the simple MATCH function to check this. If an ID number is NOT found, the MATCH function will give a #N/A result. So our formula just has to check if the MATCH is #N/A or not. We use the Excel ISNA function to check for this.

So the second helper column will now show Y for those rows that are to be deleted.

You can use a Filter on this helper column etc etc etc

Now, are you really using Excel 2003 for this????

zeddy

[rollis13]

Hi to all.
I came up with this macro:

Please Login or Register  to view this content.

[genoa]

Hi

Now, are you really using Excel 2003 for this????

zeddy

Works perfectly. Many thanks.

Excel version. Typo originally, should have been 2013 and never updated. Whoops.

[genoa]

Thank you. I'll try that later.

[genoa]

Works perfectly. Grazie.

[rollis13]

Glad we were able to help .