Results 1 to 10 of 10

Permutations without repetition using options in categories

Threaded View

  1. #7
    Registered User
    Join Date
    10-05-2016
    Location
    -
    MS-Off Ver
    2010
    Posts
    4

    Re: Permutations without repetition using options in categories

    Thanks guys! This really helps. Both of your answers do the trick. I am trying to understand what you did and see if I can work with it. I was looking at both your examples how it would work if I want to add parameters of options in the category.
    Could you explain to me some things in the formulas?

    John:

    =INT((ROWS($1:1)-1)/9)+1 What is the information selected? Why 9?

    =MOD(INT((ROWS($1:1)-1)/3);3)+1 I understand the first "3" is the position as in 1/3 or 2/3. What is the second 3?

    =MOD((ROWS($1:1)-1);3)+1 same question and why the +1?

    Davsth:

    From your example it is more clear on where the formule gets the information. And I was able to add options and categories, I just can't get the positions right, so I end up with several zero's. Also, I am getting the same option several times, and I need every permutation to be unique.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-10-2014, 02:23 PM
  2. vba code to restrict horizontal categories items repetition
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2014, 09:16 AM
  3. Replies: 1
    Last Post: 05-15-2013, 06:55 AM
  4. VBA - Permutations without repetition
    By Urbo13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2012, 11:17 AM
  5. Replies: 0
    Last Post: 07-22-2011, 03:51 PM
  6. Categories and Sub-Categories in Column Charts
    By theoneness in forum Excel General
    Replies: 2
    Last Post: 11-28-2009, 10:05 PM
  7. Repetition
    By EAMOG in forum Excel General
    Replies: 5
    Last Post: 12-15-2008, 06:37 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