Hi all, I was wondering if any of you had any idea how to do this:
I have a set of data, ex: {60,40,20,10,5}
I want to find all the different ways I can add up numbers in that, all the results being less than 100.
ex: 60+40=100, 60+20+10+5=95, etc.
The best solution for me would be if someone knew how to do this in excel, because I dont have any compilers on my computer, and I dont know much programming save for some C and JavaScript. I know that it can be done in Excel somehow, so someone here must know how!
Thanks,
E
I have a set of data, ex: {60,40,20,10,5}
I want to find all the different ways I can add up numbers in that, all the results being less than 100.
ex: 60+40=100, 60+20+10+5=95, etc.
The best solution for me would be if someone knew how to do this in excel, because I dont have any compilers on my computer, and I dont know much programming save for some C and JavaScript. I know that it can be done in Excel somehow, so someone here must know how!
Thanks,
E