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...


    Code
    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.


    e.g


    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. :)

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/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]