R
RobcPettit
Hi, I have a columns labelles A B C D E under which are numbers. Is
there a way, in combinations of 3, to work out all the possible
combinations that = a certain total using vba.
eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and
simply saying x = a + b + c....etc. Then taking the variables and
finding which ones = my target. Thought Id ask incase somebodys already
done this.
Regards Robert
there a way, in combinations of 3, to work out all the possible
combinations that = a certain total using vba.
eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and
simply saying x = a + b + c....etc. Then taking the variables and
finding which ones = my target. Thought Id ask incase somebodys already
done this.
Regards Robert