So I'm having a formula which is TextJoining headers and outputting them in one cell, but based on the data I might end up with duplicates.
The formula which I have now it's looking In for example cell A1 if there is "Code1" then it's looking under cell A2 in another sheet and there is "Code1" it's outputting the header of that second sheet which is located in A1, but the real problem is when you have "Code1" in A3 as well then you see the header twice. I have tried with unique or match, but no luck.
This is example of my formula - =IF(AND(E2<>"",COUNTA(Sheet2!$D$1:$BS$1)=COLUMNS(Sheet2!D1:BS1)),TEXTJOIN(",",,IF(E2=Sheet2!$D$2:$BS$428,Sheet2!$D$1:$BS$1,"")),"")
Thanks in advance.
The formula which I have now it's looking In for example cell A1 if there is "Code1" then it's looking under cell A2 in another sheet and there is "Code1" it's outputting the header of that second sheet which is located in A1, but the real problem is when you have "Code1" in A3 as well then you see the header twice. I have tried with unique or match, but no luck.
This is example of my formula - =IF(AND(E2<>"",COUNTA(Sheet2!$D$1:$BS$1)=COLUMNS(Sheet2!D1:BS1)),TEXTJOIN(",",,IF(E2=Sheet2!$D$2:$BS$428,Sheet2!$D$1:$BS$1,"")),"")
Thanks in advance.