Forum Discussion
Solved
Array to text conditional
Hi, I am new to formulas so I ask for your help: I wish to obtain an array to text field in column D for each change on column A. What function do I need to use. I put a sample: code size ...
In D2:
=IF(A2=A1,"",TEXTJOIN(",",TRUE,IF($A$2:$A$1000=A2,$B$2:$B$1000,"")))If you don't have Microsoft 365 or Office 2021, but Office 2019, confirm with Ctrl+Shift+Enter.
Fill down.
In D2:
=IF(A2=A1,"",TEXTJOIN(",",TRUE,IF($A$2:$A$1000=A2,$B$2:$B$1000,"")))
If you don't have Microsoft 365 or Office 2021, but Office 2019, confirm with Ctrl+Shift+Enter.
Fill down.
