Create possible combinations from three variables
 

Using Excel, I would like to create a list of all possible combinations of
a group of variables. Below is an example of what I am looking for:

Variables: Moisture, ash, protein

Results:
moisture, ash, protein
moisture, ash
moisture, protein
moisture
ash, protein
ash
protein

Thanks for any suggestions.

Create possible combinations from three variables
 

I received an answer to the same question last year:

http://www.microsoft.com/communities...2-b6a19c6fc282

John Coleman's response worked very well.
--
Gary's Student


"JoeD" wrote:

Using Excel, I would like to create a list of all possible combinations of
a group of variables. Below is an example of what I am looking for:

Variables: Moisture, ash, protein

Results:
moisture, ash, protein
moisture, ash
moisture, protein
moisture
ash, protein
ash
protein

Thanks for any suggestions.

Create possible combinations from three variables
 

Thank you "Gary's Student" for your quick response and for the link.

JoeD

"Gary''s Student" wrote:

I received an answer to the same question last year:

http://www.microsoft.com/communities...2-b6a19c6fc282

John Coleman's response worked very well.
--
Gary's Student


"JoeD" wrote:

Using Excel, I would like to create a list of all possible combinations of
a group of variables. Below is an example of what I am looking for:

Variables: Moisture, ash, protein

Results:
moisture, ash, protein
moisture, ash
moisture, protein
moisture
ash, protein
ash
protein

Thanks for any suggestions.

Create possible combinations from three variables
 

You are very welcome.
--
Gary''s Student


"JoeD" wrote:

Thank you "Gary's Student" for your quick response and for the link.

JoeD

"Gary''s Student" wrote:

I received an answer to the same question last year:

http://www.microsoft.com/communities...2-b6a19c6fc282

John Coleman's response worked very well.
--
Gary's Student


"JoeD" wrote:

Using Excel, I would like to create a list of all possible combinations of
a group of variables. Below is an example of what I am looking for:

Variables: Moisture, ash, protein

Results:
moisture, ash, protein
moisture, ash
moisture, protein
moisture
ash, protein
ash
protein

Thanks for any suggestions.