Scripting Dictionary to find unique pair of values from two different columns

Originally Posted by sriley5

Script below is my failed attempt

So in this case use the Excel basics which resolve your need just with 4 statements !

According to your attachment a VBA beginner starter demonstration :

PHP Code: 

Sub Demo1()
         Sheet2.[D5].CurrentRegion.Offset(1).Clear
    With Sheet1.UsedRange.Rows("2:" & Sheet1.UsedRange.Rows.Count).Columns
        .Item(5).Copy Sheet2.[D6]
        .Item(3).Copy Sheet2.[E6]
    End With
         Sheet2.[D5].CurrentRegion.RemoveDuplicates Array(1, 2), xlYes
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Maras_mak,

Looks like the modified version still looks for unique found in the ID column, I need the unique values of the combined Customer and ID - Sorry if I didnt make that clearer in my first posting

Marc L,

Works like a charm Thank you

Yes, just concat the columns as keys for example (different ways but using the Excel basics is so easy and works too on Mac) …