permuations

I have the following list in an excel sheet Column A Red Green Blue White Black Question : I’m looking for a script of some kind that will create a permutation of all these words that’s possible without repeating. However, with minor thing the items of red and green must be...

Hi All, I am new user and I have some similar requirement. I need permutation of A, B, C and D but I also need to specify maximum how many times each letter can occur. i.e I need A to appear max 4 times, B 2 times, C 2 time and D 2 times. Valid examples AAAA, AAAB, AABB, AACC, CCDD (since...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; min-height: 14.0px}span.s1 {text-decoration: underline}</style>Hello Mr.Excel Forum - What an amazing forum! I...

Morning all, I wonder if anyone can help for potentially a simple Excel solution. I send a lot of items in the post and with the price increase by the Royal Mail I now need different stamps than before. Is it possible to create a spreadsheet that would give me a solution to the question "How...

I have a column that has duplicate information in its rows. The rows contain a list of 4 digit numbers in each cell. An example of three of the cells is: B1: 1970,1971,1972,1974 B2: 1970,1917,1972,1975 B3: 1970,1971,1927,1976 I want a function OR <acronym title="visual basic for applications"...

I have 5 variables that input into a function. I want to review every possible combination/permutation of the variables and select the one that maximizes the output of this function. To create every possible combination, the variables will have a minimum, maximum, and interval it will test...