Generate random combinations only one number from each group of 4 letters

Where groups A, B, C, D are stored?
What are their members?

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that both: input data and your desired solution(s) is/are also shown (mock up the results manually).

OK, and next 4 are:
06 47
74 60

Why not
02 25
52 20

I can see no 45 groups you refer to in your sample file.
So nothing to scan.

If you treat each color as a group, then there is only 24 of them

If I may interject, it is not clear to me what you are doing. If I understand correctly (even if I am uncertain in the details), I expect that the core of the algorithm will be INDEX() and RANDBETWEEN() functions (Function help files: INDEX() https://support.office.com/en-us/art...2-b56b061328bd
RANDBETWEEN(): https://support.office.com/en-us/art...f-a469ab381685 ) Something like =INDEX($A$1:$B$2,RANDBETWEEN(1,2),RANDBETWEEN(1,2)) will randomly return one of the four values in that block of cells.

Does that help get you started?

I'm still not sure I understand. Why wouldn't =INDEX($A$1:$B$2,RANDBETWEEN(1,2),RANDBETWEEN(1,2) -- =INDEX($A$3:$B$4,RANDBETWEEN(1,2),RANDBETWEEN(1,2) -- =INDEX($A$5:$B$6,RANDBETWEEN(1,2),RANDBETWEEN(1,2) -- etc. work for you?

If you must use VBA, the same thing could be done in VBA using the Cells() method and VBA's random number generating function.

Can I assume that you mean Cartesian Product (https://en.wikipedia.org/wiki/Cartesian_product ) here?

In an arrangement like you show in post #16, I would probably simply use a suitable CONCATENATE() formula with the correct mix of relative and absolute references. Assuming the numbers in post 16 are in A2:A5 and B1:E1, perhaps something like =CONCATENATE($A2,B$1) in B2 and copied down and across. Note the mix of relative and absolute references. (Aside. You say that you don't know anything about Excel. Among the first lessons I ever learned about spreadsheets was how to mix relative and absolute references as described here: https://support.office.com/en-us/art...es_in_formulas )

With data in other arrangements, I would still expect to use the INDEX() function or .Cells() method to access individual elements in each set/block/array, then combine elements as desired.

If you need help understanding the .Cells() method: https://msdn.microsoft.com/en-us/VBA...e-object-excel

I've been trying to understand for already some time. And may be - I got it (or may be not )

In columns FGHI expected result is that there shall be numbers from A1:B2, A3:B4, A5:B6 and A7:B8 in a way that one of them is from each corner of An:Bn+1 square.

So with jorels nomenclature we shall randomly select numbers from each of 4 squares, but observing the rule that every one of them shall be from different position ABCD, ABDC, ACBD, ACDB etc.

and the same for next for squares A9:B16, etc.

As these data go down to B48 we will end up with 24 numbers in cells Fx:ACx.

(still wondering where is

we have 45 groups, you have to generate 40 numbers

mentioned in post #5)

The following code generates 1000 of such sets.

Please Login or Register  to view this content.

Hi rehanavaidya.

Welcome to the forum.

Please note that it's excel forum, not keno forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.