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:

=IFERROR(LEFT(ARRAYFORMULA(CONCATENATE(REPT(ET:ET&",",FA:FA=FA2))),LEN(ARRAYFORMULA(CONCATENATE(REPT(ET:ET&",",FA:FA=FA2))))-1),"")
There is a number or 1-3 characters in ET so this returns something like:

6,7,8,9,6,7,8,9
S,M,L,XL,S,M,L,XL
Instead, I need it to return:

6789,6789
SMLXL,SMLXL
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:

6,7,8,9,6,7  is never a possibility
it would always be:

6,7,8,9,6,7,8,9
Any help at all is greatly appreciated!