Hey there,
I've been researching this for a while and couldnt find anything, so I am asking here.
I am using a Textjoin Array function to write down all customer_IDs that receive a certain Coupon_ID. The function is as followed:
TEXTJOIN ", ", 1 , REPT Customer_ID ; Coupon_Match = Coupon_ID + 0
So my result is correct and looks for example like this:
yogurt_2 | 4310023099
nuts_2 | 4310023099, 4310023099, 401
But I want it to look like the following:
yogurt_2 | 4310023099
nuts_2 | 4310023099, 401
I've tried to eliminate double values with IF and MATCH function, but then it just deleted all "4310023099", even the one from yogurt_2.
Any Ideas? Maybe also for Macros?
Thanks!
Nora
Bookmarks