Remove highest rows of duplicate data

[MuppetReaper]

I'm running a process that imports data into a excel table and this can be done multiple times, so I want a way to remove the older instances and only keep the newest, which would be furthest down the table.
When I've tried using the remove dupes function it always removes the bottom values, is there a way in VBA to force it to remove the older entries?
I'm basing the dupes in values in columns A and C
thanks

 

[Fluff]

This is perfectly possible. A couple of questions
Do you want to delete the entire row for duplicates?
Do both col A & col C have to match to be considered a duplicate? (ie any row that has both Muppet in col A And Reaper in col C)

 

[MuppetReaper]

Hi, yes, I need to delete the entire row and yes, both columns need to match (A is date and C is a ref no.)
thanks

 

[Fluff]

Ok, how about

Sub DeleteDupes()

   Dim Rng As Range
   Dim Cnt As Long
   Dim Valu As String
   
   With CreateObject("scripting.dictionary")
      For Cnt = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
         Valu = Range("A" & Cnt).Value & Range("C" & Cnt).Value
         If Not .exists(Valu) Then
            .Add Valu, Nothing
         ElseIf Rng Is Nothing Then
            Set Rng = Range("A" & Cnt)
         Else
            Set Rng = Union(Rng, Range("A" & Cnt))
         End If
      Next Cnt
   End With
   Rng.EntireRow.[COLOR=#0000ff]Interior.Color = 230[/COLOR]
   
End Sub

Initially this will simply put a background fill on the rows to be deleted. If it's ok then change the part in blue & replace with .Delete

 

[MuppetReaper]

thanks, I'll give that a try