Help generating vallues from a list....

Question

I am trying to help my wife with her business. I was trying to use VBA code and custom functions to generate an array, listing all possible combinations of 4 products from a list of 20 products. I had then planned to generate in the column next to the end of each row a simple formula that calculated the price of each combination of items.

I downloaded Kutools because I could not get get VBA to work. I managed to generate a list of all possible 4 product combinations, HOWEVER, they are in a single cell. I cannot make a formula that uses the product name to pair with a price when there are 4 seperate words in a single cell, seperated by -. is there a way to use kutools or another excel function, preferably formula, to recognize each word still even though they are in the same cell? Kutools combination list also has repeats. I do not want any repeated items. All possible combinations of 4 products with no repeats from 20. Can i change how kutools makes the list to remove repeats?

The goal is to make her a price list. showing all possible DIFFERENT 4 product combinations and the total retail value of all 4. Can I use kutools for it, or should I just be typing it all in manually

Bir listeden değer üretmeye yardımcı olun ...