Combinations of Numbers/Options....Difficult VBA?

CapsHockey · Mar 20th, 2002, 01:35 PM

Here's what we're trying to do. We have 4 columns or groups of data. Each column/group may have 3 to 12 items. We are trying to get all possible combinations that would result from taking one item from each group. Hope that makes sense........

Al Chara · Mar 20th, 2002, 02:48 PM

I am not going to work out the problem but take a look at the Analysis TookPak Addin.

Mar 20th, 2002, 02:48 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I am not going to work out the problem but take a look at the Analysis TookPak Addin. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 01:35 PM	#1
CapsHockey New Member Join Date: Feb 2002 Posts: 5	Here's what we're trying to do. We have 4 columns or groups of data. Each column/group may have 3 to 12 items. We are trying to get all possible combinations that would result from taking one item from each group. Hope that makes sense........