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.

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.

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.

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.