Removing rows based on prescence in another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ianwitt - 25 Jul 2006 16:23 GMT

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...

Signature

ianwitt

Reply to this Message

Tom Hutchins - 25 Jul 2006 19:54 GMT

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

> Hello,
>
[quoted text clipped - 5 lines]
> I hope that makes sense and someone can suggest a way that I can do
> this...

Reply to this Message

Rate this thread: