'Composing' numbers
Assume the following situation:
7 rows containing numbers like: Row 1: 1,2,4,8 Row 2: 5,10 Row 3: 5,10 Row 4: 5,10 Row 5: 1,2,4,8 Row 6: 1,2,4,8 Row 7: 1,2,4,8 Then, from these numbers, one is picked per each row (e.g. into column E); finally, cell E8 then gives an aggregate of the seven selected numbers. What I want the code to accomplish is: if I need the aggregate to be 25, what are all the possibilities (7 numbers) of picking one number from each row to add up to this sum? And for aggregate of 30, 35, and so on? All ideas welcome!!! |
'Composing' numbers
See:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu200772 "Mac" wrote: Assume the following situation: 7 rows containing numbers like: Row 1: 1,2,4,8 Row 2: 5,10 Row 3: 5,10 Row 4: 5,10 Row 5: 1,2,4,8 Row 6: 1,2,4,8 Row 7: 1,2,4,8 Then, from these numbers, one is picked per each row (e.g. into column E); finally, cell E8 then gives an aggregate of the seven selected numbers. What I want the code to accomplish is: if I need the aggregate to be 25, what are all the possibilities (7 numbers) of picking one number from each row to add up to this sum? And for aggregate of 30, 35, and so on? All ideas welcome!!! |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com