combination
 

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

combination
 

See:


http://www.microsoft.com/communities...2-b6a19c6fc282
--
Gary's Student


" wrote:

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

combination
 

Thankyou fpr your reply, very usefull.
Regards Robert


Gary''s Student wrote:
See:


http://www.microsoft.com/communities...2-b6a19c6fc282
--
Gary's Student


" wrote:

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