excel again :)

[Gitano]

Thank You ATI!
I adjust the numbers #1's as in picture with your suggestion, but arise the problem in S  COLUMN  Now it show only zeros ..instead of count the distances ...it happen only in column S 

[ati]

That's because in the formula you added a space for blank values (" ") and I didn't. You need to delete the space in your formulas or add a space to my formulas. Then it should be okay.

[Gitano]

 
All right! it was a simple space! good.
Now I need to think to the other columns ..
Thank You ATI

[nottophammer]

Big Bro Ben
Help.
Do I need find, lookup. Tried somethings,got no where.
Thanks.

[ati]

Sorry, I know you didn't ask me, but you could use a simple IF and OR argument. Just copy this to the B1 cell
=IF(OR(A1=2,A1=4,A1=6,A1=8,A1=10,A1=11,A1=13,A1=15,A1=17,A1=20,A1=22,A1=24,A1=26,A1=28,A1=29,A1=31,A1=33,A1=35),"B",IF(A1=0,0,"R"))

This is not an elegant way to do it, but it's simple and works. You could also use the vlookup function, but for that you need to create two columns somewhere on your sheet, one containing the numbers 0 to 36, and the the other the colours.

[Azim]

Notto,

Try this. Enter values in Column A. Leave the lookup sheet the way it is.

Up to 250 spins.

[Bigbroben]

Notto,

Azim's sheet is good.

If you want it all on the same sheet, just cut the lookup reference and paste it where you want.  I like having all references on the same sheet then hiding the columns, but that's me.

Bref, you got the basic formulas with Azim's.

[nottophammer]

Thanks to all. Some more, if you can; please.

[nottophammer]

All who replied, thanks.
If, we could see if, or when it goes 12 spins.
+100 units on that sequence, as Foxy said, no pressure as the mat has shown where too bet.

[Azim]

Notto,

Here you go. Enter the number in the same column "A"

[nottophammer]

I’ve moved the sequence of 12 colours, okay, this is option 2 on the mat. Out of 250 spins, 122 wins.
Max spin to win, 8spins.

[nottophammer]

Azim thank you.
Those spins are from 20'000 live . So, I have a lot to go through.

Using mat options, just like GUT, I watch and decide when to bet.

[nottophammer]

213 spins; 101 wins. Max spin to win; is again 8 spins.
I, said to member leoncino74, watch and wait; said wait for 3 or 4 spins. Here, with the max of 8, then win within 4 spins. If, and I’ve not seen 12 spins, it would cost 8 spins.
Look to what’s trending.

[nottophammer]

Azim, what the PM about.
Pic 1; the sequence wins 1st spin. So we just re-bet the sequence.
Pic 2; the sequence moves down and it's a win. Just re-bet the sequence.
Pic 3, the sequence moves down and wins.

Soon as a win, re-start the sequence.
If you look to cells D22, how many wins for the 22 spins?

[Azim]

Check you PM.