Removing double-ups from Concatenate User defined function (UDF)

Hi All,

I have UDF that allows me to concatenate multiple values into one cell from a lookup function. This works really well, however I am encountering a situation with double-ups in some circumstances. I wish to combine any double-ups into one which I think will have to be done prior to the UDF. I guess my question is; Is it something I can do with the UDF or how else do i go about it?

Here is the UDF code i used;

Please Login or Register  to view this content.

Hear is an example spreadsheet which shows the problem I am having.

Concatenate Example.xlsm

Cheers,

Spicey

or this

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.