bwhamilton
New Member
- Joined
- Dec 18, 2008
- Messages
- 29
hey guys.
I have a column with a bunch of promotion types that have to be recoded to a specific format. I can think of a few ways to do it by using if statements in a macro, but no way to basically count the number of entries within a cell (i.e. buy one get one free, rebate, loyalty card = BOGO + 2 other promos).
for example:
A cell may contain: 50% Off, Loyalty Card Required, Other Purchase Required / Buy/Get - Other, Loyalty Card Required
This cell would have to get recoded Discount + 3 other promotions (3 entries separated by commas after the initial entry of 50% off).
I dont know if this makes sense, but I could really appreciate any help.
I have a column with a bunch of promotion types that have to be recoded to a specific format. I can think of a few ways to do it by using if statements in a macro, but no way to basically count the number of entries within a cell (i.e. buy one get one free, rebate, loyalty card = BOGO + 2 other promos).
for example:
A cell may contain: 50% Off, Loyalty Card Required, Other Purchase Required / Buy/Get - Other, Loyalty Card Required
This cell would have to get recoded Discount + 3 other promotions (3 entries separated by commas after the initial entry of 50% off).
I dont know if this makes sense, but I could really appreciate any help.