Modifying code for different columns

[wellsw]

The below formula will remove duplicates based on column A and B it will also apend column D with the values before removing the duplicate.

For the following statement, am I correct in thinking i,1 is referring to column A and i, 2 to Column B . so If I want to have it join with column A and C I just increment the i,2 to i,3??
What is the Chr(2)

Please Login or Register  to view this content.

for this statement would I just change all 3 of the 4's to 5's if I needed to apend column E vice D?

Please Login or Register  to view this content.

Please Login or Register  to view this content.