Thank you stnkynts. That works in spirit, but it replaces the formula in the cell with the concatenated text minus the duplicates. The issue then is that as we add more projects with more states, the concatenated string of text won't update.

Any other ideas?

M