View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maijiuli maijiuli is offline
external usenet poster
 
Posts: 56
Default formula to find all possible combinations

Hello,

Is there something in Excel 2003 to find all possible combinations of a set.
For example if I have:

Employee
Spouse
Domestic Partner
Child
Children
DP Child
DP Children

How do I find all the possible combinations? Like:

Employee only is one combination
Employee + Spouse is one combination
Employee + Spouse + Child is one combination

Please let me know if this is possible?
--
Thank You!