I thought I knew how to do this, but I am stumped by what must be a basic issue. I have spent an hour searching this forum, but to no effect.
I have seven "components" which I want to combine in different ways to make "products"
I want to find out the number of ways I could combine the different components to make different products. The =COMBIN formula doesn't do it properly (ie for all possible combinations)
Having found out this total it would also be nice if I could get a list of the possible combinations <g>
Help much appreciated