Hello all,Looking to write 3 to 4 step script/code for the following.
Excel 2003 spreedsheet, STEP 1..Cell A1 to A49 has (min of 6 number to the max of 49 number but can change at my well) many cells will be blank.
EXP.
A1 2
A2 4
A3 7
A4 8
A5 13
A6 16
A7 22
A8 25
A9 29
A10 31
..........and so on always Smallest to largest.
STEP 2...Combination of (6 or 7 my choice) None repetiton (C n over r = N 10 over R6(N10-R6)=...............= 210 and have the SUM of each as well.) Dont need to see it.
STEP 3...Show only those combintation with a SUM range from _ to _( 145 to 155 my choice to change at my well) have it show Step 3 from D1 down to D? how ever many there is.. hoping not alot!!!
Please and Thanks A.Rose
Bookmarks