given 24 numbers, (97,101,139,41,37,31,29,89,23,19,8,13,131,19,73,97,19,139,79,67,61,17,113,127)taken 5 at a time, generate the unique combinations add up to 200. so, num combination to test 42504, optimal results 27 groups of 5 numbers : example (8-17-37-41-97)-(8-13-37-41-101)
etc. this program is in java. How is possible to do this in EXCEL 2003 .
You can see number 23 is in third place and four, 10,16,17, I would like to generate a list of positions for any number I choose, in this case for 23 the list will be 3,4,10,16,17, how is possible to do in excel 2003.
given 24 numbers, (97,101,139,41,37,31,29,89,23,19,8,13,131,19,73,97,19,139,79,67,61,17,113,127)taken 5 at a time, generate the unique combinations add up to 200. so, num combination to test 42504, optimal results 27 groups of 5 numbers : example (8-17-37-41-97)-(8-13-37-41-101)
etc. this program is in java. How is possible to do this in EXCEL 2003 .
37no37 4 months ago
cell-01.02.03.04.05.06.07.08.09.10.11.12.13.14.15.16.17.18.
-----17.19.23.23.29.29.37.19.19.23.29.37.41.19.19.23.23.29
You can see number 23 is in third place and four, 10,16,17, I would like to generate a list of positions for any number I choose, in this case for 23 the list will be 3,4,10,16,17, how is possible to do in excel 2003.
37no37 4 months ago