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 | I wish to be like this | |
| 5 | s | s,m,xl,xxl | |
| 5 | m | ||
| 5 | xl | ||
| 5 | xxl | ||
| 2 | s | s,m,l,xl,xxl,xxxl | |
| 2 | m | ||
| 2 | l | ||
| 2 | xl | ||
| 2 | xxl | ||
| 2 | xxxl | ||
| 3 | s | s,m,l,xl | |
| 3 | m | ||
| 3 | l | ||
| 3 | xl |
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.
2 Replies
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.
