Hello All,
I've been searching for a solution to this unique excel issue for the past few days without luck.
I have a spreadsheet that has data in Columns a, b, and C. This data is customer name, whether or not the code is optional or required, and the code
The first step I took was using the following formula =TEXTJOIN(",",TRUE,FILTER($C$2:$C$8019,$A$2:$A$8019=$F2))
This formula helped contenate the codes listed in column C based on the customer name to create a unique code for that customer.
However, i only did this for required but there are also optional codes. The reason I didn't contenate these is because the optional codes can vary:
For example it would be all required plus one of the optional, all required plus two of the optional, all required plus option 1 and 3, all required plus option 2 and 4, ect.
The constant is the required i.e those will always be included but where it varies is the optional requirements and I need to figure out a way to list out all possible options.
I am wondering if there is a macro, formula, or any other solution that could assist?
I've been searching for a solution to this unique excel issue for the past few days without luck.
I have a spreadsheet that has data in Columns a, b, and C. This data is customer name, whether or not the code is optional or required, and the code
The first step I took was using the following formula =TEXTJOIN(",",TRUE,FILTER($C$2:$C$8019,$A$2:$A$8019=$F2))
This formula helped contenate the codes listed in column C based on the customer name to create a unique code for that customer.
However, i only did this for required but there are also optional codes. The reason I didn't contenate these is because the optional codes can vary:
For example it would be all required plus one of the optional, all required plus two of the optional, all required plus option 1 and 3, all required plus option 2 and 4, ect.
The constant is the required i.e those will always be included but where it varies is the optional requirements and I need to figure out a way to list out all possible options.
I am wondering if there is a macro, formula, or any other solution that could assist?