Deleting Duplicate rows...VBA Code

**robkozak** · 05-24-2008, 10:19 AM

I have found a bit of code that deletes duplicates and keeps rows based on the the highest value in column B.

BM411757 1
BM411757 2
BM411757 3

So the results of below code would be:

BM411757 3

however I am looking for something that would delete the row with the higest value. Result would be:

BM411757 1
BM411757 2

I haven't been able to adjust this code to work this out. Could someone help with this. Many thanks in advance.

Rob

Please Login or Register  to view this content.

**Richard Buttrey** · 05-24-2008, 11:54 AM

Hi,

Try the following modified code.

HTH

Please Login or Register  to view this content.

**robkozak** · 05-24-2008, 12:22 PM

Hi Richard,

Thanks for your response.

I have tried this. It works well when there is 2 or 3 duplicates but when there are 4 or 5 duplicates it deletes the 2nd and 3rd row respectively instead of the 4th or 5th.

example for when there is 4 duplicates:

BM411757 1
BM411757 3

and for 5 duplicates:

BM411757 1
BM411757 2
BM411757 4

Many thanks
Rob

**Richard Buttrey** · 05-24-2008, 01:12 PM

Hi Rob,

Try this variation

Please Login or Register  to view this content.

**robkozak** · 05-24-2008, 01:25 PM

thats great thanks Richard

**VBA Noob** · 05-24-2008, 03:46 PM

robkozak,

Please read forum rules below. Cross posting on other forums without the link is not permitted

VBA Noob

Deleting Duplicate rows...VBA Code

LinkBack

Thread Tools

Rate This Thread

Display

Deleting Duplicate rows...VBA Code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions