TEXTJOIN - getting 1 occurrence of duplicate values only

[aTRc]

Hi,
I have searched the forum, but no similar problem found.

Underlying code returns the info I want, but has doubles.
I would want to see only occurrence of each value.

Please Login or Register  to view this content.

ActiveCell.FormulaArray = "=TEXTJOIN(""" & Delimit & """,TRUE,IF(" & LookUpRange & " = " & LookUpValue & "," & ResultRange & ",""""))"

Please Login or Register  to view this content.

which results in this formula:

Please Login or Register  to view this content.

However I would want to see 1 occurrence of every duplicate values only.
See attachment. In example I want the outpu as in Cell I4 and I6, instead of the formula resulting in H4 and I4.
Found different leads, but can't figure out a simple answer.

Any help appreciated.
A

[XLent]

One option, in terms of native formula, which you could use in your code (not provided)

Please Login or Register  to view this content.

note: c/o INDEX the above does not require Array entry, i.e. can be confirmed with Enter {no more efficient, just arguably a little more robust}

[aTRc]

Hi XLent

That did the trick. Resolved.
Thank you very much, also for the additional info!

Greetz
aTRc

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.