Hello,
This one seems tricky to me.
I basically want any duplicate email addresses to auto concatenate the tags.
Example the first 3, "[email protected]"[/email], would give the final cell result of "Retail, Commercial, Investment".
A few of them have just 2 and a few have 5 duplicate addresses.
Any help would be appreciated.
Thank you
Edit: I should also add that there are a maximum of 5 tags: Retail, Commercial, Office, Investment, Industrial
Anything less than that will have a different combination of tags, so there can't be a static formula.
forum.ozgrid.com/index.php?attachment/44973/