Re: Cell Calculation

Hi thanks,

It works ok but in this example what i need to do is establish if there are ANY combinations that are equal 27 if so, display those first and then output each additional item/items that are less than 27.

so as in my last example:

27 (+ the relevent bin numbers and their associated values)

27 (+ the relevent bin numbers and their associated values)

6 (+ the relevent bin numbers and their associated values)

For course there may be instances where there aren't any combinations equal to 27, therefore they could all be output as separate lines. Or as in the following example, the 2nd and 3rd lines may equal 27 but not the 1st line.

21 Bin1

12 Bin2

15 Bin3

Output as:

27 Bin2 12; Bin3 15;

21 Bin 1 21;

Any more help please?

Thanks again,