How to recursively build a string concatenation using an array

[junfanbl]

Hey everyone, I have an interesting need that I think is somewhat challenging. It is just enough to keep things interesting but not too hard.

I have an array that stores the value of about 10,000 different cells in Excel. The data stored in the array needs to be written to a spreadsheet in a specific way. I need to build up string concatenations based on whether or not the array elements match each other. So for every matching string in the array, I need to store that value in a concatenated string.

Can somebody give me some example code on how I might achieve this?

[westconn1]

probably you have not posted enough information for a valid contribution of code

what is the criteria for the array elements to match?

you could possibly look at adding all the array items to a collection
a collection will not allow duplicate values, so if an error occurs when adding an item, then concatenate the values