I made a table consisting in four main columns, from B to E, and 14 named products. Supposing I can only handle 5 at a time, a formula calculates the efficiency of the combination (based on data that's not in the image). The column B is what triggers the calculation: typing "1" makes the product an active part of the combination.
Remember I need to have 5 activated at a time and always 5. Is there a way to make Excel cycle through combinations? Combining products A, B, C, D and E gives 47,5% efficiency, but there are 2002 combinations, so I wonder if Excel can do that for me, because I wanted to know which combination gives me the best average efficiency.
Excel.JPG
Bookmarks