I was given a list of available products but the codes need to be translated to my setup. To top it off, the way the information was given to me is really bad.
Essentially I was given 2 columns
Colunn A is CardNumber and Column B is AvailableProducts
For this exercise, CardNumber is irrelevant. The format of column be is what is causing me the problem. It is essentially a list of product codes, separated by commas. The list can also vary in length, for Example
Column A Column B
Card1 1,4,5,25,96
Card2 4,7,25,96
My dilemma comes in that in Column C - G need to put an 'X' if I see a value.
For example in Column C I will need to put an 'X' if I see a 1 or 5 or 19. In column D I will need an 'X' if I see a 20 or 96.
Given the above rows, Card1 would have an 'X' in both column C and Column D but Card 2 would only have an 'X' in Column D.
Any help would be appreciated. I was hoping Excel would have a 'Contain' or 'Like' function but I haven't found one that works.
Essentially I was given 2 columns
Colunn A is CardNumber and Column B is AvailableProducts
For this exercise, CardNumber is irrelevant. The format of column be is what is causing me the problem. It is essentially a list of product codes, separated by commas. The list can also vary in length, for Example
Column A Column B
Card1 1,4,5,25,96
Card2 4,7,25,96
My dilemma comes in that in Column C - G need to put an 'X' if I see a value.
For example in Column C I will need to put an 'X' if I see a 1 or 5 or 19. In column D I will need an 'X' if I see a 20 or 96.
Given the above rows, Card1 would have an 'X' in both column C and Column D but Card 2 would only have an 'X' in Column D.
Any help would be appreciated. I was hoping Excel would have a 'Contain' or 'Like' function but I haven't found one that works.
