View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nevermore Nevermore is offline
external usenet poster
 
Posts: 4
Default How to create a complete list of combinations from 5 options

I have a list of 5 possible options that I need to assemble into combinations
of 3 (order does not matter). I want to make sure the list is complete and
I'd rather not do it by hand. Can excel (or access) help me with this and how?

The order of the variables doesn't matter so 121 is the same to me as 112 or
211.