how many combinations are possible of the suit with a number on each line .

[jorel]

how many combinations are possible of the suit with a number on each line
can not have two numbers in the same row already in the column can
01 02 03
04 05 06
07 08 09
* ex = 01 02 07 = can not because there are two numbers of the same
* line (01.02) the limit is a
but in the columns can = ex
01 04 07, or 02,04,07 ... please

[Kaper]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jorel]

hello, kaper. I type the amount I want, in each block, the middle column (x) does not enter the connations
the macro will generate the formations as I select the numbers in each sector
note = can not have two connations on the same line
* ex
01 02 03 = only one mark
is for soccer games
* can not, for example, have 02 03, together.
* to select the numbers I can type
https://www.excelforum.com/attachmen...1&d=1522781518

[Kaper]

Still do not understand what you want to achieve

Include a BEFORE sheet and an AFTER sheet in the workbook

[jorel]

hello, KAPER, is for football lottery,
* I choose the digit numbers in each of the quadrants, and the macro create the combinations according to the quantity chosen in each block

[AliGW]

Jorel - Kaper has asked you to provide a sample before and after. Please do so.

If you insist on helpers here doing all your work for you and never trying to adapt solutions yourself, then at the very least you should supply ALL the data they ask for instead of the bare minimum.

[Kaper]

Dear Jorel,

I'm quiting and unsubscribing from this thread.

Sorry to say so, but it's not the first time (nor second, nor third) when I try to help you. And have tu guess what you are asking for. Spending much more time on trying to guess what is the idea behind, what is expected result, and what rule(s) drive to such result, than on real excel question.

So as I said - I'm quitting now.

But wish you good luck in next lotteries. Hoping that some day you win main prize (and then you recall your declaration: https://www.excelforum.com/excel-pro...ml#post3928691 :-) )

[jorel]

hello KAPER
https://www.excelforum.com/attachmen...1&d=1523009749

[AliGW]

Kaper has given up on you, Jorel.

Your attachment is not a great deal of help as it does not make it clear what is source data and what is the data that you wish to generate.

It has some pretty colours, though.

[jorel]

ok the macro, will find each block
scoring with (x) on each draw line
the macro will identify in the matrix the right

[AliGW]

And what are the rules? What logic will the macro need to apply to do this?

In other words, what are the steps you would take to do what you have already done manually?

Do you understand the expression, "It's like getting blood out of a stone"?

[jorel]

now, we have, the draw lines,
* we have 4 blocks and center line, is just to see each, where each draw line passes, what macro
* will look in the matrix of the 4 blocks, where the lottery, the macro or formula passed, locate m the value (x) that is to say in which block this

[AliGW]

Good luck!