All the combinations possible
Posted by Don Levesque on January 14, 2002 7:35 AM
I've got cell A1 with a total amount and in B2 to H2 I've got specific numbers.
Is there a formula or macro I can build to find all the possible combinations of B2 to H2 that would give me the amount of A1 and write these combination in another section of my sheet.
Example: A1=12 B2=2 C2=3 D2=4 E2=5 F2=6
The possible combinations are: 6xB2, 4xC2, 3xD2, 2xF2, 1xB2+2xE2, 2xB2+2xD2, and so on.
I'm using Excel 97.