Duplicate Merge

  • Re: Duplicate Merge

    One more pesky question.

    If I ever wanted to change the columns that are compared, which line do I modify? I assumed it was...

    1. txt = Join$(Array(a(i, 2), a(i, 3), a(i, 4)), ";;")

    But it doesn't match the columns in terms of letters to numbers.

    Thank you.

  • Re: Duplicate Merge

    Your worksheet has blank in col.A so the numbers in array corresponding to the columns are 1 less than a column index in the sheet.


    Column.B = 1 in array
    Column.C = 2 in array
    and so on.

    Is this what you are asking?

  • Re: Duplicate Merge

    I see what you mean Jindon ..I obviously used the Dictionary object to create a new unique array - So I ended up using 2 arrays and you used only one. Very clever. Learn something new everyday. Thanks. :)

    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]