VLOOKUP & Delete Rows

Hi soulfly, welcome to the forum. Yes, that's clear. For this I would add a column to sheet 1. Let's call column D "Key", and in D2 put this formula:

=COUNTIF(Sheet2!$A:$A,$A2)>0

Now copy that cell down the whole dataset. You now have TRUE/FALSE answers for each name.

Click on A1 and select DATA > FILTER > AUTOFILTER to turn it on.

Now click on D1's drop box and select FALSE to see only the names that AREN'T on Sheet 2.

The benefit of this approach is that it let's you filter by whatever criteria you want, hiding the rows that don't fit the criteria without actually deleting them.

Now, if you really WANT to delete the rows, autofilter for "True" answers, then highlight the visible data and select EDIT > DELETE ROW. Then set the Autofilter to "All" to get the remaining data to show.

Thanks for your valuable reply. I was looking for it for long. I'm lucky to be part of this forum.

Let me try, I will knock again if I face any prob

--------------------------

Fantastic... it worked... Thanks a million

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)