Comparing two columns and filtering unique

[trixie2396]

So I have these two sets of data... I would like to filter and find only the rows where the ID is the same but the score is different. Is there a way to do that? So in the example below it would have two records after filtered, it would have 137379777 and 013450341

Score ID Score ID
10 128833548 10 128833548
8 034932806 8 034932806
5 137379777 8 137379777
9 031068078 9 031068078
5 013450341 8 013450341

 

[trixie2396]

anyone?

 

[marka87uk]

Can you not do something like this, where it'll show a 1 if the ID is the same but the Score is diffferent?

=IF(AND(D2=B2,A2<>C2),1,0)

 

[MickG]

Not exactly sure what you want , but this will hide the rows you don't want !!!

Private Sub CommandButton1_Click()
Dim Rng As Range, Dn As Range
Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
For Each Dn In Rng
    If Dn(, 2) = Dn(, 4) And Dn = Dn(, 3) Then
         Dn.EntireRow.Hidden = True
    End If
Next Dn
End Sub

To Unhide rows

Private Sub CommandButton2_Click()
Rows.Hidden = False
End Sub