+ Reply to Thread
Results 1 to 4 of 4

Finding unique combinations

  1. 01-09-2012, 06:35 PM #1
    jharaldson
    jharaldson is offline
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Finding unique combinations

    Can someone help me with finding unique combinations. Something like:

    12
    1234

    would have a total of 6 combinations, 12,13,14,21,23,24. And another:

    67
    12345

    would have a total of 10 combinations, 61,62,63,64,65,71,72,73,74,75.

    Thanks
    Reply With QuoteRegister To Reply
  2. 01-09-2012, 08:54 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Finding unique combinations

    There's a workbook that will do this at http://www.box.com/shared/ubd28tissi
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 01-09-2012, 10:16 PM #3
    jharaldson
    jharaldson is offline
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Finding unique combinations

    shg,

    Thanks for the response but I am not quite sure I understand that worksheet. Could you explain it a little, please.

    Thanks
    Reply With QuoteRegister To Reply
  4. 01-10-2012, 11:40 AM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Finding unique combinations

    Delete all but two columns, enter 6-7 in the first column and 1-2-3-4-5 in the second.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1