number combo generator?

not hard to do, but one or two things need clarification. Let's assume that there are 3 numbers and they are 1, 2, 3

Then 123 would be an obvious combination, as would 213 or 321

1. are all numbers integers?

2. do you wish to include any combination or only combinations with all three numbers? For example, is 12 an acceptable combination?

3. do you wish to create combinations with or without replacement, i.e., is 111 or 222 or 333 an acceptable combination?

thankyou for your reply and questions. To clarify further, if I had five columns of digits (all integers) and needed all possible combinations. Let's say I had the the following integers in column one. (1,3,5). In column two I had (3,5,7). In column three I had (5,7,9,). In column four I had (7,9,11). In column five (9,11,13).

I need all combinations that are in consecutive order from least to greatest. For example, combinations such as:

1,3,5,7,9
1,5,9,11,13

are allowed

5,3,7,11,13
5,5,9,11,13

are not allowed

no two numbers are allowed to repeat and any number to the right is not allowed to be less in value to the one to the left.

Again, any help would be greatly appreciated.

Thankyou

Thanks, that clears up your problem quite a bit. One final question ...

In your reply, you define 5 sequences, (1,3,5), (3,5,7), (5,7,9,), (7,9,11), and (9,11,13). That yields 7 unique numbers: 1, 3, 5, 7, 9, 11, and 13. You then indicate that the combination 1,3,5,7,9 and the combination 1,5,9,11,13 are acceptable. Both of these happen to be 5 numbers long. So if I understand the logic, then any monatonically increasing sequence of length 5 drawn from the original unique numbers is acceptable; and other acceptable combinations would include:
1, 3, 5, 9, 11
1, 3, 5, 9, 13
3, 5, 7, 9, 11
3, 5, 7, 9, 13
etc.

Correct?

That's correct. Also, I didn't mention before but you probably realized, all number sequences are five digits in length.

Thank you.

Originally Posted by yungexec

That's correct. Also, I didn't mention before but you probably realized, all number sequences are five digits in length.

Thank you.

I suspect you meant 5 numbers in length, not digits.

Attached is a zipped spreadsheet that should do what you want.

Let me know if this works ...

I am happy that the code is close to what you want. Writing the "results" to another worksheet is simple, but before we do that, let's get the basics working correctly

The other restriction needs clarification. In you original post, you had the same number in multiple columns. For example, "1" was in col 1, col 2 and col 3. If your restriction states that only one number can be drawn from each column, can the number replicated in multiple columns be used multiple times? Should your "rule" be restated as " ... no number can be equal or less than a number to the left ..." ?

This new restriction does change how things are handled, but tweaking the code to do this should not be too difficult.

What is the likely # of values per column? The exact number is not important, but the code might be different if the # were 100 vs 5. Similarly, how many columns are typical? Again, the exact number is not important.

Finally, re "sending me something": this forum is set up to help people. It is expected that as users become more experienced and skilled, they will be able to help others. So, do not just seek help; log on now an again and see if there is someone you can help.