Thread: How to create a complete list of combinations from 5 options
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default How to create a complete list of combinations from 5 options
Assuming with Mike Middleton that you want
combinations with repetition, 35 in this case,
and you don't want to use a macro,
then try this tandem Pivot Table approach:
http://www.savefile.com/files/1610285
Reply With QuoteReply With Quote