View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JoeD
 
Posts: n/a
Default 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.