LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a list of options with only one being selectable? Quincy Jones Excel Discussion (Misc queries) 1 April 8th 07 03:40 AM
I have 5 columns of data and want to create combinations based on Carbob Excel Discussion (Misc queries) 0 June 2nd 06 04:58 PM
Create possible combinations from three variables JoeD Excel Discussion (Misc queries) 3 April 20th 06 10:20 PM
create an automatic complete list from existing data in the sheet Etienne Excel Discussion (Misc queries) 2 February 8th 06 01:55 PM
Macro to add numbers to create combinations that equal certain amo Lauren qt314 Excel Discussion (Misc queries) 3 April 21st 05 05:57 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"