avoid duplicates in the formula

[bee123]

How to avoid duplictaes here ?

I have a formula we are using generally in most of our worksheets.


Here its.


I have a table T1 nad mainly 3 columns.


CustomerID , Value, Displaytext


Column Displaytext gives value according to the formula =if(T1[[#this row];[Value]]=1;C1&", "&T1[[#this row];[CustomerId]];C1)


Getting column values as

Filesent_1

Filesent_1,2

filesent_2,3 etc


then the end of the Displaytext column we have


=Replace(INDEx([Displaytext];Rows(T1));1;length(T1[[#heading];[Displaytext]])+2;"")


Here im getting the only the customerID


it shows as 1,2,4,3,4


Repeating the customer id agian and agian ,how can I correct this?


I have to correct in this formula.


=Replace(INDEx([Displaytext];Rows(T1));1;length(T1[[#heading];[Displaytext]])+2;"")


how to do this?