Hi,
I'm trying to make a dynamic array with a bunch of concatened SKUs. The codes are built merging different other codes separated by a letter with each block representing some info. The first block holds the first 3 numbers and ends by the letter "M", and corresponds to the brand of the product. What I'm trying to do is: based on a column holding each and every brand code and according to an adjacent column carrying true/false statements for each of these codes, I thought maybe I could look through all concatenated value in a string and deactivate all codes marked as false.
If it was a single value I think I could come up with something maybe using LEFT, SUBSTITUTE and maybe INDEX to check an array, but I have no idea how to achieve this with multiple concatenated values that vary in quantity (though separated by ";" and having the same lenght for each code block).
I'll be really thankful if anyone could help me out, maybe at least pointing out a way.
I'm attaching a sample represeting the situation.
Bookmarks