Macro to Filter and Delete Row for Duplicate Entries

Andrew,

Alternate method:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Tigeravatar,

What does intersect do? Is it available only in 2010?

arlu1201,

Intersect is available from Excel 97 and up I believe. (I haven't actually used earlier than Excel 2003).

To quote cpearson at http://www.cpearson.com/excel/Events.aspx :
"Intersect returns a range of cells that are included in two ranges. For example, the Intersection of the range A1:C3 and C3:F6 is the cell C3 since that cell is common to both ranges. If there are no cells in common between two ranges, Intersect returns Nothing"

Hope that helps,
~tigeravatar

You guys are the best! Thank you so much!
One more addition if I may, I have one more column (D).. That has Either ABC and EFG.
Could you also help me include a filter on that to remove and delete the rows that has EFG?
Hope I'm not asking for too much.

Many thanks!
Andrew

Andrew,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

@tigeravatar
Thank you sir, any chance I could out together the first code you gave and the second one?
Just to clean up the code? I tried merging them but with no luck.
Basically what I'd like to achieve is:
- Remove rows with duplicates from Column C
- Remove rows with Value EFG on column D

Thanks for your patience sir

Andrew,

One way:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Bingo! Worked perfect sir! Thank you!
This will save me a lot of time! Thank you! Thank you! ^^