To DILIPandey about False Positive Results of a VBA Code.

Hi DILIPandey,

Sorry to bother again. The following is a code that you developed to help me replacing the repeated data with "same as above". Most of the time, it works very well. However, sometimes it creates "False Positive" results, replacing values that were not equal. Could you please help me explain why that happens. Thanks in advance.

Best regards,

Matt

PHP Code: 

Sub DILIPandey()
'checking duplicates
i = Range("l" & Rows.Count).End(xlUp).Row
k = 0
Range("l" & i, "P" & i).Select
For n = 1 To i - 1
    For Each cell In Selection
        If cell = cell.Offset(-1, 0) Then
            k = k + 1
        End If
        If k = 5 Then
            Selection.Value = "same as above"
        k = 0
        End If
    Next
Selection.Offset(-1, 0).Select
Next
End Sub 


Hi ProtonLeah,

The code for the attached file works perfectly. I add the code to another Macro to get what I need to be done in a worksheet, and that's the time that false positive happened, replacing rows that not the same.

If needed, I can post the code that I created and a file that has the problem. Thanks.

Best regards,

Matt