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!