Hi Folks,
I could really use some help figuring out how to find all matches within a specified array, and then to display them with duplicates separated by delimeter.
With the reference (constant) in FA, and the info to be returned in ET, I am currently using this formula:
There is a number or 1-3 characters in ET so this returns something like:
Instead, I need it to return:
So basically instead of concatinating with commas between each returned character, I need it to place the comma delimeter only between duplicated sets.
One thing to note is that the numbers/characters returned will always be exact duplicates. So:
it would always be:
Any help at all is greatly appreciated!
Bookmarks