Results 1 to 8 of 8

Macro to ORDER unique combinations

Threaded View

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Macro to ORDER unique combinations

    Hi

    I'm not sure if this is possible, but here goes.

    I have three columns of letters

    Screenshot (1).jpg

    Column A is my list of 5 variables
    Columns B and C are my list of unique two digit combinations of column A (done using a macro)

    In column D, with the first row (A and B) being combination number 1, I would like to order the list of columns B and C such that the next on the list is the first combination not to contain either of the previous two values, meaning that the next in the list is row 8 (C and D), it should then loop through the list to find the next unassigned row that doesn't contain either C or D which means the next row will be row 4 (A and E) it then goes back through the list to find the next unassigned row not containing the previous two letters which would be row 5 (B and C) and so on and so on.

    Any help would be much appreciated!

    Many thanks

    Martin
    Last edited by woodsquash; 05-02-2014 at 07:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unique combinations of 7
    By ricardojaworski in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 11:56 AM
  2. Help calculating frequency of order combinations
    By LukeG11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2013, 10:23 AM
  3. Macro to concatenate unique combinations??
    By oubravs2b in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2012, 08:29 AM
  4. Generate combinations for a variable number of columns in order
    By q83 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2011, 04:17 PM
  5. count unique combinations
    By mini in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2006, 07:50 AM

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