in other word , i need a function that selects uniqe records of a long list
and combine them with a comma seprator in a cell

gr_jafari



"gr_jafari" wrote:

Dear Kevin B , many thanks for answer , but i want to do that with a function
that operats automatically and flexible.

"Kevin B" wrote:
Just concatenate each cell value, excluding the duplicate, in cell A6
=A1&", "&A2&", "&A3&", "&A5
--
Kevin Backmann


"gr_jafari" wrote:

I have thoes text in A1:A5 and now want to have that string in A6 , pleas any
help

ColumnA
1 book
2 pencil
3 pen
4 pen
5 book
6 book,pencil,pen