+ Reply to Thread
Results 1 to 4 of 4

Show possible colour combinations.

  1. #1
    Registered User
    Join Date
    02-25-2011
    Location
    UK
    MS-Off Ver
    Excel:Mac 2008
    Posts
    2

    Show possible colour combinations.

    I hope this is in the right place and that it's OK to post this kind of question.

    I'm making a blanket using 7 colours to make many squares which will be sewn together.
    Each square uses 3 colours, in a concentric ring pattern kind of like a bullseye. I want to use every possible combination of these 7 colours in this ring pattern. Order in the ring matters so:
    'Pink, blue, yellow' and 'yellow pink blue' would both count as different combinations of the colours.
    It's been a while since I did any of this kind of maths but I think there will be 210 possible combinations in total.

    OK so my question is, is there a way to get excel to tell me all of the possible combinations/ orders of the 3 colours. So I would have a kind of list I could tick off when I'd used one.
    I know this sounds like a pretty trivial problem but I've become really interested in the maths behind this project. I'd really appreciate any help or hints.
    Thanks.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Show possible colour combinations.

    Maybe this:
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-25-2011
    Location
    UK
    MS-Off Ver
    Excel:Mac 2008
    Posts
    2

    Re: Show possible colour combinations.

    That's almost it. I should have said each colour can be used only once in each combination. I can just ignore the ones with repeats though.
    Thank you so much

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Show possible colour combinations.

    I was thinking of doing this with VBA, but zbor's solution is easier and fits the bill. I have made a modification that adds columns to show just the combinations with unique colors and numbers them. Hope that is somewhat useful.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1