jonastiger
Member
Hi
Hope you're all going well
I'm trying to get distinct values using TextJoin function, no sucess.
Please see file example attached:
My formula in K8
I will be very thankful if someone help me to solve this issue.
PS: I work with EXCEL 2019
Thanks
JT
Hope you're all going well
I'm trying to get distinct values using TextJoin function, no sucess.
Please see file example attached:
My formula in K8
Code:
=IF(J8="";"";TEXTJOIN(",";TRUE;IF(MATCH(Table1[SER];Table1[SER];0)=MATCH(ROW(Table1[SER]);ROW(Table1[SER]));Table1[SER];""))*(Table1[LOC]=J8)*(Table1[CL]=$G$7))
I will be very thankful if someone help me to solve this issue.
PS: I work with EXCEL 2019
Thanks
JT