Create possible combinations from three variables

[JoeD]

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.

 

[Gary''s Student]

I received an answer to the same question last year:

http://www.microsoft.com/communitie...&p=1&tid=1fd10426-1802-47e1-b372-b6a19c6fc282

John Coleman's response worked very well.

 

[JoeD]

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

JoeD

 

[Gary''s Student]

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

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

JoeD