Combinations

[douglas.osborne]

Hi,

I have a list of 28 items, 14 of them are of a fixed mass but 10 of them have various options. Is there a way to display all of the possible combinations and the associated total mass?

I have attached a simplied version of the spreadsheet to try and help illustrate my question.

Thanks,
Douglas

[mojo249]

Hi

Firstly, how do you intend to display them? In a listbox? Or a combobox?

Also, if an item has more than one mass, do you want to display a separate entry for each mass, such as:

Item 16 0.062
Item 17 0.120
Item 17 0.110
Item 17 0.095
Item 18 0.035
etc

Or do you want to sum the masses for each item, such as:

Item 16 0.062
Item 17 0.325
Item 18 0.035
etc

Dion