Extract Differences Between 2 Comma Separated Range Arrays

  • Re: Extract Differences Between 2 Comma Separated Range Arrays


    Try this. It's complicated a little because sometimes your arrays contain spaces.

  • Re: Extract Differences Between 2 Comma Separated Range Arrays


    Here are 2 custom functions you can use;

    Use in cells like[frc]=GetDiffs1(A2,B2)[/frc]and[frc]=GetDiffs2(A2,B2)[/frc]See example in file.

  • Re: Extract Differences Between 2 Comma Separated Range Arrays


    Thank you, really nice solution!
    Another solution that I found:


    Attached a file ..


    The question is how to remove "commas" at the beginning?

  • Re: Extract Differences Between 2 Comma Separated Range Arrays


    Change

    Code
    If FoundFlag = False Then
                CompareTwoArr = CompareTwoArr & "," & TempValue
            End I


    by

    Code
    If FoundFlag = False Then
                If (CompareTwoArr = Empty) Then
                        CompareTwoArr = TempValue
                    Else
                        CompareTwoArr = CompareTwoArr & "," & TempValue
                End If

    Triumph without peril brings no glory: Just try

  • Re: Extract Differences Between 2 Comma Separated Range Arrays


    Or add;

    Code
    CompareTwoArr =Trim(Right(CompareTwoArr, Len(CompareTwoArr) - 1))

    Here

    Code
    Next i 
    CompareTwoArr =Trim(Right(CompareTwoArr, Len(CompareTwoArr) - 1))
    End Function

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!