Finding differences in two columns

[sboutte42178]

I have two columns, one (Column A) with a list submitted last week, and another (Column B) from this week. I need to see if i can sort out only new items in list B. That way each week, I'm submitting new items weekly. These are all dumps from access, so i might have to do this there.

Any suggestions?

 

[kidwispa]

If you are using excel 2007 or later:

In C2 and copy down:

=IFERROR(VLOOKUP(B2,$A$2:$A$500,1,0),"")

In older versions of excel:

=IF(ISERROR(VLOOKUP(B2,$A$2:$A$500,1,0),"",VLOOKUP(B2,$A$2:$A$500,1,0))

 

[GTO]

If by code, maybe:

Option Explicit
    
Sub exa()
Dim DIC1 As Object
Dim DIC2 As Object
Dim Vals1 As Variant
Dim Vals2 As Variant
Dim Val As Variant
Dim wks As Worksheet
    
    Set DIC1 = CreateObject("Scripting.Dictionary")
    Set DIC2 = CreateObject("Scripting.Dictionary")
    '// Chnage worksheet name to suit                                   //
    Set wks = ThisWorkbook.Worksheets("Sheet1")
    
    With wks
        '// Change start row to 2 if header                             //
        Vals1 = Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp)).Value
        Vals2 = Range(.Cells(1, 2), .Cells(.Rows.Count, 2).End(xlUp)).Value
        
        For Each Val In Vals1
            DIC1.Item(Val) = Empty
        Next
        
        For Each Val In Vals2
            If Not DIC1.Exists(Val) Then DIC2.Item(Val) = Empty
        Next
        '// Plunk wherever                                                  //
        .Range("D1").Resize(DIC2.Count, 1).Value = Application.Transpose(DIC2.Keys)
    End With
End Sub

 

[sboutte42178]

Thanks!