List Character Combinations

Feb 3, 2008

I know the COMBIN function, i want to list all combinations from a given set of cells (numbers), each item of the combination - in separate cell. Example:

1 2 3 4 5 a b 6 ....

after combin (x,3) i want to list me this: 123........but each number must be in separate cell (1-one cell, 2 -one cell, 3 -one cell)

124
125
12a
12b
126
234
etc

List Of All Possible Combinations Of The Integers

Jan 19, 2009

A user would input 4 integers.
How can I generate a list of all possible combinations of the integers?

Generating A Combinations List

Feb 5, 2007

I have ten numbers (i.e. 1,2,3,4,5,6,7,8,9,10) and I'm trying to figure out how to make Excel generate a list of all the combinations possible for these 10 numbers. I'm trying to avoid using a VBA script. Is it possible to accomplish this task only using a function formula? This way I will have the ability to tweak the formula and test different qauntities of numbers (i.e. 1,2,3,4,5,6,7 or 44,56,77,33). Is getting a list of all possible combinations to output on a single column with commas between numbers possible with a formula?

List Out 6_49 Lottery Combinations Only Those With The Sum Of 100

Sep 3, 2009

I need a vba that can generate all set of 6 number combinations with the total sum of 100.
For example: 3, 6, 4, 15, 35, 37 = 100.

List Possible Combinations With Conditions/Constraints

Aug 9, 2008

I am trying to write VBA code that will list all possible combinations of data contained in a worksheet based on a few conditions. I have a list that varies in length. In the first column is a list of numbers denoting a particular course number. In the second column is a list of numbers denoting the specific class number for the course. As an example, I have a 6 courses. The first course has 1 class, the second course has 3 classes, the third has 11, the fourth has 3, the fifth has 7, and the sixth has 6. Thus, my columns look like this:

A B
1 1
2 1
2 2
2 3
3 1
3 2
3 3
3 4
3 5
...

I need to list out all possible combinations of classes given that I must have all six courses. EXAMPLE (Course, Class):.......................

Output All Combinations Of List Of Given Numbers With Repetition?

May 10, 2014

I need to be able to create a list of all combinations (where position doesn't matter, therefore its not a permutation) of a list of numbers with repetition enabled. I need to provide anywhere up to at least 10-15 numbers if possible and they are integers normally between 1 and 72. Example: (for numbers 1, 2, 3)

VB:
1
2
3

[Code]....

Produce A List Of Combinations From A Range Of Numbers?

May 9, 2014

Am looking for an easy way to produce a list of combinations (maximum 6 numbers) from a range of numbers listed in 6 different columns:

Example
Column A contains : 1,2,3
Column B contains : 7,8,11,15
Column C contains : 12,16,18,19
Column D contains : 17,30,31
Column E contains : 30,31,32,33,34
Column F contains : 37,39,40
The rules are:

In each combination of 6 numbers, numbers should always be taken from ALL 6 columns. In each combination, numbers cannot repeat.

show me a formula to arrive the results.

Generate List Of Combinations - 20 Questions With 3 Answers

Feb 26, 2011

How to generate a list of numbers of this function in Excel: COMBIN(20,3), but i want the combinations of numbers. I want to create a list of 20 questions and every question has 3 answer. I think that are 1140 combinations.

Finding All Unique Combinations Of List Of Words?

Dec 6, 2011

I have 15 different words that I want to order in as many ways as possible, but only 3 at a time.

So let's say the words are:

cat
dog
elf
clown
monkey
rock
bananas
(etc)

then I want a list that has all of these possible combinations:

cat dog elf
cat dog clown
cat dog monkey
cat dog rock
cat dog bananas
cat elf clown
cat elf monkey
(etc)

until all are listed. I understand there is a huge number, I don't mind having a couple of thousand as long as they are all genuinely unique.

I CAN have elf dog cat, elf cat dog, dog elf cat later on ... it's just the order that needs to be unique not the words in the phrase.

List All Possible Outcome Combinations For 50 Football Matches

Dec 20, 2012

An example will be as follows. List all possible outcomes for 3 matches. That will be 27 possible outcomes.

I would like results for my request of 50 matches to be displayed as follows.

HHH
HHD
HHA
HDH
HDD
HDA

[Code] ...........

Where:
H=HOME
D=DRAW
A=AWAY

Is there a way i can have the possible outcomes listed as above for the outcomes of 50 football matches? I do know that the outcomes will be hundreds of millions if not billions.

List All The Combinations Of A Group Of Cells Containing Letters, But Not Numbers

Feb 9, 2008

I have 7 cells containing strings but not numbers on a row.

Now I want to list out all the combinations of drawing out 3 cells out of these 7 cells while the remaining cells that haven't been drawn out could also be listed out one column next to the drawn cells.

For example, I got 7 cells like this.

A B C D E F G (each letter in ONE cell)

And I want to list out all the combinations like this:

ABC DEFG
ABD CEFG
ABE CDFG
ABF CDEG

etc.

For more details, please refer to the attached sample (an .xls file being zipped).

All Combinations Of Breeding Outcome From List Of Male And Female

Jul 17, 2012

I breed snakes as a hobby and have around 30 females and 15 males Different morphs of Royal Python

There are a few things i am trying to do and will start of by asking the most simple one

If i have a column of females and a column of males can a formula be made to show all the possible pairings between male and female?

List All Possible Combinations Of Single Range In Two Separate Columns

Apr 25, 2013

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:

Column A:
Column B:
Column C

0001
0001
0001

[Code] ......

How To Generate All Combinations Of Ten Values List / Picking In 4 Each Combination

Oct 20, 2013

I have a list in excel with ten values, but I need to get all combinations possible, picking 4 of 10 each combination. This must be as a combination and no permutation or variations either, I mean, values can't be repeated in a single combination.

I'm struggling to do this in a Macro but I don't get it.

Number Combinations :: 25 Random Numbers (5 Digit Combinations)

Dec 15, 2008

I have 25 random numbers and I would like to get a possible 5 digit combinations of these numbers. Can anybody help me with the possible formula?

Generating List Of Combinations With Both Unique / Independent And Dependent Input

Mar 26, 2012

I coordinate access requests for several contracts, and I have to list the approved accesses in a list where each line represents one person and one contract. For each access request, there will be an arbitrary number of persons obtaining access to an arbitrary number of contracts.

The input would then be as follows: Joe A and Jill B request access to contracts 1001, 1002 and 1003 ->

Joe A   1001
Joe A   1002
Joe A   1003
Jill B     1001
Jill B     1002
Jill B     1003

To automate this task, I have made a simple macro for generating a combination list of all persons having obtained access to a selection of contracts.

My macro worked well when I only wanted to list unique and independent list items, but now I have been asked to include each person's email address. How I can change my code so that only one email address is copied into my list for each person?

Code:
Sub AccessList()
Sheets("requests").Select
Dim rng As Range, c As Range
Dim rng1 As Range, c1 As Range
Dim rng2 As Range, c2 As Range

[Code]....

Number Combinations :: Between 7 To 15 (6 Digit Combinations)

Jun 30, 2008

What I am looking for is to select between 7 and 15 numbers in total, I want all the possible 6 digit combinations for this.

EG: if I choose 2,9,11,13,15,17&26, it would look something like this

2,9,11,13,15,17
2,9,11,13,15,26
9,11,13,15,17,26
And so on.

If I chose more numbers (10) 1,2,3,4,3,6,7,8,9,10 it would start something like this

1,2,3,4,5,6
1,2,3,4,5,7
1,2,3,4,5,8
1,2,3,4,5,9
1,2,3,4,5,10
And so on.

Please remenber I would like to be able to secelt between 7 and 15 number and be given all the possible combinations.

I would like it to be in one sheet but if that can not be done on as many as it takes.

It would be good if I could just type the required number into A1,B1,C1 and so on and they just gave the combinations required.

Sum First Character Of List Of Values

May 13, 2013

I'm looking for a formula that can sum the first character of a list of values together, based on the cagegory.

Example below:

Column A = The category (or name of a person)
Column B = The status, I'm interested in the first character of the status (which is always a number)
Column C = The sum of the status based on the first character of the status for that specific person

James
1.0 Not Started
8

James
8

[Code] .....

I want to do this without adding another column (i.e. I can get the result adding a column with formula "=value(left(B2,1))", but I don't want to add the extra column)

I'd also prefer to avoid doing this with a macro, as this part of the formula is only a smaller part in a larger formula.

I tried to look for an entry in this forum, but couldn't find one that matches what I need.

Like Operator Not Working For Character List

Aug 14, 2014

When I run this code it does the exact opposite of what I want it do (if not contained in that character list then delete). So basically if it not in the character list then delete, but it if is in the character list it deletes....

[Code] .....

Alphabetic Character Permetation List

Jun 30, 2006

I need to create a list of all possible permetations of all 26 alpha characters when put into a 3 character string. EG: AAA, AAB, AAC, through to ZZZ. Is this something that can be done in excel/vba?

Get List Box Value To The Left Of Character And Paste It Into Cell

May 17, 2013

I've created a user form that has a list box populated with a fairly standardized format - a product ID or model number followed by a dash ( - ) then followed by a description. Based on the users selection of an item in the listbox, certain rows will be copied over from another tab in the excel file.

An error occurs when a Model Number list box item is selected but not when a product ID is selected.

The difference between the two are AlphaNumeric vs only numeric.

USBLT15CMB - Product Description 1
1121 - Product Description 2

the code is:

Private Sub CommandButton1_Click()
Dim ID As Long
Dim Row As Long
Dim Cnt As Long

[Code]...

The macro stops on the ID = line

Changing Selected List Option To Single Character?

Jul 7, 2009

I'm creating an excel spreadsheet that will be sent out to a few users to enter data into. In this spreadsheet, multiple columns contain drop down lists created using the Data Validation tool. The lists are referencing named ranges on a second worksheet.

In these drop down lists are terms that consists of one or two words. What I'm trying to do is when a user goes to select an option from the drop down list, I want the matching one letter code to be entered into the cell instead. For example,
Column AK has drop down list with following options:

Good
Moderate
Poor

When a user selects one of the options, I want one the following respective letter to appear instead......

Jan 5, 2014

This is my data validation formula:

=INDIRECT(VLOOKUP(H104,cat_opt_Table,3,FALSE))

Some of the lists will have up to 200 lines in them and I'd like to find a way to simply to jump to the first letter entered in the data validation cell.

Does the list need to be alphabetized?

Could it be something that is entered into the data validation box? This spreadsheet has data validation in 35 columns.

How To Remove Special Character Without Disturbing Other Character

Nov 27, 2012

To all sifus out there, how can i transfer from these:

NAS517-3-2
-41353913
NAS517-3-5
NAS517-3-4
-42MS27253-2
-43353908
-44357182

To these:

NAS517-3-2
353913
NAS517-3-5
NAS517-3-4
MS27253-2
353908
357182

Append All Digits Before Character To All Numbers Between The Same Character

May 18, 2008

I have got a list of numeric abbreviations, for instance 10739011/21/31/41. What it should really display are the numbers 10739011, 10739021, 10739031 and 10739041 (the first six figures stay the same). All the numbers in my list are 8 figures long. I want to change the list from the list seperated by the backward slash to the complete numbers. I have uploaded an example of the list with backward slash between the numbers. Is there a way that Excel can automatically change these numbers to the full numbers?

Because all the numbers are 8 figures long, I thought the first 6 figures of the 1st number can be copied and those 6 figures pasted before the other two figures after the backslash. Auto Merged Post Until 24 Hrs Passes;sorry, pressed OK too quickly. The problem is that there are sometimes 4 numbers in the cell, sometimes 6 and once three. I would like Excel to complete all the numbers in the cell and then move on to the cell underneath it and so on. Also, I would like each number to have it's own cell.

Look For Character In Cell And Insert New Character - For More Than One

Sep 20, 2009

I have a cell which will contain SER01+SER02+SER03

and what i need it to contain is [SER01]+[SER02]+[SER03]

and shocker is i've got this to work for the first instance but not the other two

code as below... be grateful for your help

Sub measure1()
Dim list As String, pos As Integer, refl As String, refr As String, newlist As String
list = Cells(1472, 16).Value
pos = InStr(list, "+")
refl = Left(list, pos - 1)
refr = Right(list, pos + 1)
newlist = "[" & refl & "]"
Cells(1472, 17) = newlist
End Sub

Add Character After 1st Character Of Cells

May 6, 2008

Need a formula/code that will determine what the corrected part number should be (insert dashes if they are missing) by comparing to other values in the list.

Original A1:A5 = {452, a-bc, 123, 4-52, abc}
Corrected C1:C5 = {4-52, a-bc, 123, 4-52, a-bc}

I can do this using an intermediate working column, but can this be done all in one formula, or via VBA?

My formulaic solution is thus: .....

All Possible Combinations That Sum Up To X

Oct 19, 2007

I have a column of transactions lets say 500 or so, of irregular numbers such as 257,273.80 (not something ou can add up in your head...). I know that of those 500 transactions a handful of them have a sum of lets say 2,877,000.00, which I know. Now I need to find all possible combinations of values in this column that equal a sum I enter.

Combinations Using Formula

Dec 14, 2008

I've attached an Excel..Its a small 4X4 matrix with numbers filled inside...Next to the right is a Combinations Column..I want to know how can i use just forumla to optain 4digit combination based on the 4X4 matrix. Rule is only numbers from the 4X4 be used.

Combinations That Sum To A Given Total?

Feb 26, 2014

I have up to 30 cells each with an integral value from 1 to 5. The task is to list all the ways that selections of from 1 to 5 cells can be made from the list such that the value of the sum of the selection is 5. It will usually be the case that there will be a final selection that will not sum to 5 and this needs listing also.

I am aware of coding that can list out combinations, but not in a form that can be adapted to deal with the summing limitation. I hope that I will be able to code so that I can deal with different numbers of cells and different sum values.