Arrayfunction TEXTJOIN only receive unique values

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

Although there are formula ways to return unique values without seeing the layout of source data I am reduced to guessing. An uploaded sample Excel workbook is almost always helpful.

If you are not familiar with how to do this:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

In the meantime see if this meager sample helps any.

In B1 as in the below

Formula:

Please Login or Register  to view this content.

	A	B
1	4310023099	4310023099, 4310023098
2	4310023099
3	4310023098
4	4310023099
5	4310023099
6	4310023098
7	4310023099
8	4310023099
9	4310023099