• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

unique value

Hi
how can i add reference to the last column to see if the previous value is the same
1 is the same
2 is different
i have 1000s of lines
thanks
Dave

VendorReference
11n/a 1st lines so can't compare
111
111
111
222
112
111
 
or
Code:
Sub Maybe()
    With Range("B3:B" & Cells(Rows.Count, 1).End(xlUp).Row)
        .Formula = "=If(R[-1]C[-1] = RC[-1], 1, 2)"
        .Value = .Value
    End With
End Sub
 
Back
Top