Removing rows based on prescence in another sheet

I

ianwitt

Hello,

I have a large sheet using columns A-E and I need to remove certain
rows from it. I need to remove any row where cells A and D of that row
occur together in columns A and D of another sheet in the same row as
each other.

I hope that makes sense and someone can suggest a way that I can do
this...
 
T

Tom Hutchins

Here's one way:

On both sheets, in F1 enter =A1&D1 and copy down through all rows of data.

On the sheet where you want to delete the rows, in G1 enter
=IF(OR(LEN(F1)=0,ISERROR(VLOOKUP(F1,Sheet2!F:F,1,FALSE))),"","DELETE")
and copy down through all rows of data. Change Sheet2 to the correct sheet
name.

Column F will display DELETE in the rows to be deleted.

Hope this helps,

Hutch
 
Top