I'm very new at this, my terminology will not be good.
I have two columns that I'm working with. In one column, I have a macro that lets me select multiple options from a drop down list of 50+ options, and it will return those values in the cell separated by commas.
I want the 2nd column to search each cell for which values have been selected, and based on that, return a separate set of comma separated values.
the logic behind is it the 50+ options are subcategories, and the 2nd column will be master categories. so one cell would look like
ax,ay,az a ax,by,bz a,b ax,by,cz a,b,c
thank you very much
Bookmarks