Repeated numbers in the 14 positions

[jorel]

hello, please, locate repeated numbers in the 14 positions always
* taking as a basis the last draw for the next,
* goal = see which numbers repeat
* from the last draw to the next, and the sum.
then we have 4 groups, then find them
* are different things to do
https://www.excelforum.com/attachmen...1&d=1547152340

[MrShorty]

It seems simple, so I wonder if I am misunderstanding something.

Are the "x" markers important? It seems easier to me to use simple boolean 1s and 0s, so I have opted for a more numeric representation. Here's what I did:

1) For the first group of repetitions, I entered =--(A7=A6) into P7. Copied across to AC7.
2) Sum for this row is a simple SUM() function AD7 =SUM(P7:AC7)
3) Copy P7:AD7 and paste/fill down.

4) For the groups, I entered =--(COUNTIFS($A6:$N6,AF$5)>=1) into AF6. Note the mix of relative and absolute references. Copied across to AP6.
5) In AQ6, I entered =SUM(AF6:AP6)
6) Selected AF6:AQ6, copied, and pasted into AR6, BD6, and BP6.
7) For CB6, it looks like a simple concatenation, =CONCATENATE(AQ6," ",BC6," ",and so on).
8) CC6 looks like a confirmation sum of the four sums (should be 14 everytime??). =SUM(AQ6,BC6,...)
9) Select AF6:CC6 and copy/paste/fill down.

It should not be difficult to adapt to x/blank if that is an essential part of the spreadsheet. Did I understand correctly?

[jorel]

Okay,MrSHORTY you're correct, right here, the soccer lottery has been converted into numbers,
objective = to see the repeated markings from the last to the next is that if you hit these markings to play, the rest do not need
play triples! Do you understand this part?
ok it can be (1) in place of (x), no problem, in the 4 groups you can see that always one of them, we have 1,2,3 points in 10 markings, good standard, now you can get by in planilia, please

[MrShorty]

I won't have an opportunity to put that into a spreadsheet for upload for a day or so. I'm still not sure I understand what you want. Is there a specific formula that I suggested that you are having trouble entering/copying/pasting? A formula that gives the wrong result?

[jorel]

hello, the formula is correct, I tried, insert, but I can not

[MrShorty]

Is it a specific formula that Excel won't accept, or does Excel reject all of those formulas? Is there some kind of protection on your copy of the file that is preventing you from entering formulas? Did the file somehow get marked as "read only"? What I proposed seems to work in the sample file you uploaded. If you download a copy of the file you uploaded, can you enter any/all of those formulas into that copy of the spreadsheet?