excel help for roulette

[gianfrancopierino]

hi guys, i need help with a system, excel could help making faster and secure calculations
can you help?

[6StringJazzer]

Welcome to the Forum gianfrancopierino!

Your file does not explain itself. Can you give more description about what you are trying to do? Explain what all your data means in the context of roulette.

Also, if you are trying to develop a system that can mathematically predict roulette numbers, you are wasting your time, unless you develop a much more complex system to look for biases in the wheel or the dealer.

[gianfrancopierino]

there are 18 splits to track, inside excel
excel must wait for 2 numbers from 2 different splits, first number will give the split, lets call it Alpha 1, second number will give us the second split Alpha2
at this point excel must creat 16 groups of 3 splits each, Alpha 1 + Alpha 2 + (every other split except alpha 1 and 2)

after creating the 16 gropus, when i insert a new number, the group with that split must be canceled from the list, in my excample 17 was extract, the group, group 6 in this case, must be canceled
every time i insert a new number the group with that split must be eliminated and so on.

[gianfrancopierino]

or if tis easier, the group to be excluded can receive a colour

[MrShorty]

Are you required to store the splits as text/fractions like you are currently doing? Here's what I did:

1) Starting with the complete list of splits in G4:G21, I select G4:G21 -> Data -> Text to Columns -> Delimited "/" output to H4. H4:I21 populates with the individual numbers from the text/fraction splits.
2) In J4, I perform a conditional count for the number in H4 or I4 in A1:A3 =COUNTIFS($A$1:$A$3,H4)+COUNTIFS($A$1:$A$3,I4). This will return 0 if neither value in the split is present in A1:A3, and 1 if either value is present (or 2 if both values are present, but I'm not sure from the example if that is possible).

If I understand correctly, wherever there is a non-zero value (1 or 2 or more) in column J, you want to "cancel" from the list.

Did I understand correctly? Would a counting strategy like that work for what you are trying to do?

[gianfrancopierino]

can you put it in an excel file to test?

[MrShorty]

I might be able to later, but I've described only two relatively simple steps. Are you having trouble following my description of those two steps in your own file?

If you are having trouble with the text to columns step, this tutorial explains how to use text to columns: https://www.excel-easy.com/examples/...o-columns.html
If you are having trouble with the COUNTIFS() function, here's MSFT's help file: https://support.microsoft.com/en-us/...c-aa8c2a866842

Until I get a chance to upload a file, see what you can figure out.