Need a macro to delete first duplicate row by comparing two column

[Marison]

Hi All,

please help me with a macro that will delete first duplicate row by comparing two column.

Kindly find the reference sheet attached.

 

[Marc L]

Hi !

At beginner level using Excel basics (formula, filter & copy)
just activating the Macro Recorder !

A demonstration according to your attachment :​

Sub Demo1()
     [F1].CurrentRegion.Clear
      Application.ScreenUpdating = False
With [A1].CurrentRegion.Resize(, 4).Columns
         .Item(4).Formula = "=A1&""¤""&B1<>A2&""¤""&B2"
         .Item(4).AutoFilter 1, True
         .Item("A:C").Copy [F1]
         .AutoFilter
         .Item(4).Clear
End With
      Application.ScreenUpdating = True
End Sub

If it's not what you expect so it may occur
with a poor attachment not reflecting real data …
​