+ Reply to Thread
Results 1 to 1 of 1

Macro to generate all possible permutations of 'n choose k' binomial expansion

  1. #1
    Registered User
    Join Date
    08-02-2017
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    2010
    Posts
    20

    Macro to generate all possible permutations of 'n choose k' binomial expansion

    Have seen variations of this question posted around the web, but nothing that answers my question specifically.

    I want to generate all possible permutations of an n choose k system, where the order of the numbers matters, as they will be coordinates. I feel like this should be relatively simple, given that there is a built in fucntion on excel to find the number of combinations from such a scenario.

    So far all I can think of is to make a column of all possible n values, from which you could choose the three values (x,y,z) that I need, but I don't know how to code this. Thanks
    Last edited by macronoob1; 12-13-2017 at 11:34 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to Generate all possible combinations?
    By excelcombinations in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2017, 09:01 AM
  2. Excel to choose all possible combinations
    By doodlelurch in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-21-2017, 12:16 PM
  3. [SOLVED] generate combinations
    By H.Merlow in forum Excel General
    Replies: 3
    Last Post: 08-04-2016, 05:14 PM
  4. generate combinations
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2016, 05:31 AM
  5. Generate all possible combinations
    By muttleychess in forum Excel General
    Replies: 7
    Last Post: 09-22-2014, 02:39 PM
  6. Using Macro to generate combinations in multiple columns
    By nirvanaic822 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 06:30 AM
  7. Generate combinations
    By cjt_choccy in forum Excel General
    Replies: 6
    Last Post: 11-20-2011, 02:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1