Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating combinations (Excel 2003)

    I often have to make up master lists for lookups or sumproduct formulas of every combination of A,B,C and 1,2,3 for instance. I cannot think of a simple way to develop the combinations in a list other than manually. Is there an approach or formula or quick macro that could produce all the combinations? TYIA

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating combinations (Excel 2003)

    Are expecting results such as:
    <table border 1><td>A1</td><td>A2</td><td>A3</td><td>B1</td><td>B2</td><td>B3</td><td>C1</td><td>C2</td><td>C3</td></table>

    I use Access to generate the results I use two non linked tables in a query to generate the possible results. I've attached an example
    Attached Files Attached Files

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Creating combinations (Excel 2003)

    My Excel add-in "Display Word Permutations" may be useful?
    It is attached. It will display permutations for words or numbers up to 8 characters.
    (Order matters in permutations)
    There is also an option to flag legitimate words created in the list.
    It finds the first empty column on the active worksheet to place the list.
    A Word.doc install/use file is included.
    '--
    Jim Cone
    Portland, Oregon USA

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating combinations (Excel 2003)

    Thanks. Elegant solution. I will try it with my Excel data. I assume I can just import two workbooks into Access and use your query?

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating combinations (Excel 2003)

    You could import the whole sheet or just copy the data that you want to combine into the two tables

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •