Not the same names in the text box

[#1]

Here asked I a question:

@Names in text box

Now, I have a sort of. Some names have 3 numbers and than there are 3 the same names in the text box.

Is there an option to say that it is impossible to have the same names in the text box?

[awhitfield · Accepted solution]

Sorry pasted this on the wrong issue before, you need to use distinct in the your expression

=Concat(Distinct(Name&CHR(13)))

andy

[#3]

Thanks Andy, it is indeed another formula .

Sorry.

And it is correct~!