Array

[davidepstein22]

Hi, I wrote the formula below and it partially works. I was expecting 3 strings to return, but I am only receiving 2 strings. Syntactically, the formula is correct. I confirmed that the underlying data is correct. I narrowed the error down to the when the Match function leads into the row calculation (to remove duplicates. I can supply the data if needed. Help Please!!!

=TEXTJOIN(", ",TRUE,IF((Table18[Gram]="yes")*(Table18[Scope]="Top 6")*(Table18[Ownership]="CBS Corporation")*(MATCH(Table18[DMA Name],Table18[DMA Name],0)=(ROW(Table18[DMA Name])-ROW(Table18[[#Headers],[DMA Name]]))),Table18[DMA Name],""))

 

[Aladin Akyurek]

Try to post first 10 rows of Table18 with only relevant fields and the expected result for the posted sample.

 

[davidepstein22]

Hi, I wrote the formula below and it partially works. I was expecting 3 strings to return, but I am only receiving 2 strings. Syntactically, the formula is correct. I confirmed that the underlying data is correct. I narrowed the error down to the when the Match function leads into the row calculation (to remove duplicates. I can supply the data if needed. Help Please!!!

=TEXTJOIN(", ",TRUE,IF((Table18[Gram]="yes")*(Table18[Scope]="Top 6")*(Table18[Ownership]="CBS Corporation")*(MATCH(Table18[DMA Name],Table18[DMA Name],0)=(ROW(Table18[DMA Name])-ROW(Table18[[#Headers],[DMA Name]]))),Table18[DMA Name],""))

Hi Aladin,

Thanks for the reply. The text below (I realized) will not return a match if the condition is found in any row beyond the first occurance of the DMA Name. Do you know what function I can use to remove duplicate DMA Names from the output string?
*(MATCH(Table18[DMA Name],Table18[DMA Name],0)=(ROW(Table18[DMA Name])-ROW(Table18[[#Headers],[DMA Name]])))