Macro For Deleting Duplicates, Comparing Rows and Retaining Minimum Value

Hi,

I will appreciate your help. As shown below, I have data from Columns A to D. I want to do the
following:

1. Look for duplicates in all column A
2. For each duplicate found in column A, check if all values in column B are also duplicate.
3. If the condition in (2) is satisfied, compare column D for all the rows; select the row with the minimum value in column D, and delete the other rows.

For example:
A B C D

Row1: Abby 04/01/2014 7:00PM 0.98437
Row2: Sam 04/01/2014 9:00PM 0.35627
Row3: Abby 04/04/2014 7:00PM 0.68932
Row4: Abby 04/01/2014 7:00PM 0.63132
Row5: Abby 04/01/2014 7:00PM 0.67532
Row6: Abby 04/04/2014 7:00PM 0.24932


Since Rows 1,4 and 5 have the same values in columns A and B; and Row4 value in column E is the smallest value between the 3 rows; Delete Row 1 and 5.

Same goes with Rows 3 and 6; Delete row 3


Results
A B C D

Row2: Sam 04/01/2014 9:00PM 0.35627
Row4: Abby 04/01/2014 7:00PM 0.63132
Row6: Abby 04/04/2014 7:00PM 0.24932


Thank you for your help!

Here you go:

Please Login or Register  to view this content.

Regards,
tt3

Hi, banawaja,

if you use Excel2003 the Sort command and if I remember correctly RemoveDuplicates won´t be available. You would have to work with the old Sort command and maybe use a loop.

Please Login or Register  to view this content.

Ciao,
Holger

Hi, banawaja,

1004 is the worst documented run time error which doesn´t give much of a clue what happened. I downloaded the attachment from tt3 and tested the code on that workbook, no RTE appeared. Could you please attach a sample workbook with the code as you tried to use it to have a look at?

Ciao,
Holger