I have cells that have comma separated data that I need to combine into a single array and then remove duplicates.

For instance, D2 = "a,b,c", D3 = "b,c,d", D4 = "c,d,e" and I want my final array to show "b,c,d,e".

Due to other restrictions elsewhere in my code, I need to run a loop to add in the arrays instead of selecting them as a range (the row needs to meet certain criteria to be included).

Can anyone offer some direction on this? I did copy the functions offered at CPearson, but I am getting errors (http://www.cpearson.com/excel/VBAArrays.htm)

Thanks in advance.