Combinations in excel

Hi there,

I would like to know if statistixl could help-me on this matter.

Let's supose I have the following values in a table :

120,30
230,49
110,90
333,90
332,00
233,00
322,00
145,89
433,90
325,89
125,90
159,75
....

50 values at most. And I have a key number which is 609,38 (outside the table).

I need a software which I could type that number and then it shows me that the following combination: 230,49 + 233,00 + 145,89 = 609,38 (key number)

If I get something completely automated it would be great, but it could just list the combinations in the excel and then I search (control+L) for the key number in the results.


Can you help me with ? I am a laical on software programming, In case you know how to create something in excel I would really appreciate if you could teach me that step by step.


Tks,


Daniel

Comments

  • Hello Daniel

    Unfortunately statistiXL will not do what you require. You can download a trial of statistiXL at http://www.statistixl.com to see the features that it has but your key number scenario is not covered.

    Best regards

    Alan Roberts
    statistiXL

Sign In or Register to comment.