Hello,
I hope someone can help with this!
I have a data set with 3 columns. The first column contains a list of projects (all unique). The second column contains a list of companies (several duplicates) and the third column contains a list of states (several duplicates). For each company, I need to provide a list of the states they are operating out of. I'm using AConcat to do this, which works well, except I don't want to have duplicates in the list.
Can someone help with a function or modification to the VBA to produce a concatenated list in a cell that does not contain any duplicates?
Thank you!!
M
Bookmarks