delete lines based on value and duplicate

[VbaHell]

Hi All

I hope you can help on this please

In column "A" ! have a date (16/3/18)
In column "E" I have a name

What I want please is some VBA that will delete any duplicate Names that match the same date

16/3/18 John
16/3/18 John Delete
16/318 Jill
21/3/18 Jack
21/3/18 Jack Delete

Any help will be most welcome


EDIT: Sorry forget to mention. its the whole row that i need deleting

 

[kvsrinivasamurthy]

In 2007 version

If Data is in Column A & B

Select Whole Data

Tab DATA --> Remove Duplicates

In The Box Select Column A & Column B --> OK

Done

 

[kvsrinivasamurthy]

IF macro is required

Sub RemoveDuplicates()

ActiveSheet.Range("$A$2:$B$6").RemoveDuplicates Columns:=Array(1, 2), Header _
:=xlNo
End Sub