Remove rows that have duplicate numbers in column "A"

[IrishMist1748]

I have a table with around 6,400 rows. It has 2 columns (A and B). "A" contains an item number and "B" contains a description. My problem is some of the item numbers are duplicated with the same description. What I need to do is delete any item numbers that are duplicated and the entire row associated with that number(s).

What I have is:

ActiveSheet.Range("A:A").EntireRow.RemoveDuplicates Columns:=1

But it does not work!

Any ideas on this?

Thanks!

 

[imimin]

Try this thread (post#2), I think it will be just what you need!

http://www.mrexcel.com/forum/showthread.php?t=523558

 

[ZVI]

some of the item numbers are duplicated with the same description

If duplicates are in discription B-column then try thiis:
ActiveSheet.Range("A:A").EntireRow.RemoveDuplicates Columns:=2