permutation lists

  1. N

    Help with permutations

    I have 6 numbers and a letter (1, 2, 3, 4, 5, 6, X) that I need to list in every possible 4 digit combination that includes duplicates (i.e. 1111). Is this possible to do in Excel instead of having to manually type every one? I have seen a couple things online but it deals with Macro's, which...
  2. S

    Permutation problem

    Hi - I would like to generate all the 5 digit long permutations that can be constructed from a pool of 30 unique digits. The pool of 30 digits are: 2, 3, 4, 6, 7, 8, 9, A, B, C, D, E, F, G, H, J, K, L, M, N, P, Q, R, T, U, V, W, X, Y, Z. [O, 0, 5, S, I, 1] are excluded due to the likelihood of...
  3. Y

    Display All Permutations of a List Without Repeating Values

    Hi Everyone, I've been trying to get this to work this out for a while but am starting to struggle and am running out of time! I'm trying to optimise a running order for a show and am looking to generate all possible permutations of a possible running order with 28 acts. Below is an example of...
  4. P

    VBA Task Order Permutations with constraints and compatibility

    Good Evening, I am trying to create a list of logical schedule permutations. I have a list of 50 tasks, some can be done in parallel some may require other tasks to finish before they can begin. I am trying to write a VBA macro which goes generates a list of LOGICAL/FEASIBLE task order...
  5. J

    List all possible combinations of a single range in two seperate columns

    I have a single rangle of numbers in Column A, and in Columns B and C and want to list all possible combinations of these numbers. If there is a possible solution without using a Macro I would perfer that, but if not I'll take what I can get. Example Desired Output: <TBODY> Column A: Column...
  6. S

    Help with permutation list.

    I am trying to create a list of permutations in a column for example I need a list of numbers 1-20 with no numbers repeating. This is causing my head to hurt and I have been working on this problem for some time. So any help would be much appreciated and is much needed.

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top