Combinations Question

[ETC]

Thank you for such a helpful forum. I have found many solutions by searching and reading previous post. This time I can not find what I am looking for so here is my first post.

I am trying to determine the possible % combinations of customers under various rate plans that will equal a desired average output given a defined range of potential customers per rate plan. I actually don't need every possible combination and can keep a few of the options static (entered manually) if that makes it easier.

I have attached a version of what I am trying to accomplish just previously manually entering % values to reach a combination that equals the average rate. Thank you.

Eric

[MickeyGreen]

If I understand the problem correctly, the possible combinations are infinite.


Remember your algebra: One equation for one unknown.

i.e. I'm pretty sure you need to hold all %'s static except one and solve for that.

You could also write a vba procedure to loop through several predefined "static" plus one combinations and save them off to the side if that helps.