+ Reply to Thread
Results 1 to 3 of 3

Formula for combinations without repitition

  1. #1
    Registered User
    Join Date
    08-01-2019
    Location
    Winnipeg
    MS-Off Ver
    Office 365
    Posts
    19

    Formula for combinations without repitition

    Hi all,
    I need help with generating a list of all possible combinations without repetition
    I have a set of 14 numbers from A1 to A14.
    I need a formula to generate a list combinations (8 in a row) with above numbers without repetition (n=14, r=8). Total 3003 combinations
    I also need a formula to generate another list of combinations (7 in a row) with the above same 14 numbers without repetition (n=14, r=7) Total 3432 combinations
    Can someone please help me with formulation?

    thanks

    SG
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Formula for combinations without repitition

    =index($m:$y,2+m$1*mod((row()-1)/product(m$1:$y$1),1),column()-1)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-01-2019
    Location
    Winnipeg
    MS-Off Ver
    Office 365
    Posts
    19

    Re: Formula for combinations without repitition

    Hi tim, Thanks a lot for your help

+ 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. Logging information across different spreadsheets w/out repitition
    By JamesyD in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 08-28-2017, 12:58 AM
  2. how to count repitition
    By naeemdotcom in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2015, 02:35 AM
  3. Array formula to avoid cell value repitition
    By himanshupd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 12:22 AM
  4. Array formula to avoid cell value repitition
    By himanshupd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 12:22 AM
  5. Replies: 5
    Last Post: 07-02-2010, 11:27 AM
  6. [SOLVED] Eliminating data repitition
    By Graham in forum Excel General
    Replies: 1
    Last Post: 06-08-2005, 11:05 AM
  7. removing repitition from cells...
    By excelguru in forum Excel General
    Replies: 1
    Last Post: 01-20-2005, 06:41 PM

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