Recording macros in Excel 2007 - using the Quick Access toolbar

[37no37]

Challenge from the book wonder of numbers, the zen archery problem.

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-10­1)

but the other condition to the list is the sets has to be 3 odds and 2 even otherwise don’t show up.

(condition 3) do not repeat numbers.