how to excel some results

[gianfrancopierino]

inside the excel:

LINE A real extracted numbers
LINE B 6 random numbers

is there a command (something automatic) that can show me the longest non hit row?

[ᶦ ᵃᵐ|Ä-łëx]

Roulette Xtreme

[gianfrancopierino]

i have rx, i must go manually, i hoped excel could show me faster

[ᶦ ᵃᵐ|Ä-łëx]

Try the Gaps+DistanceCalculator

[Bigbroben]

inside the excel:

LINE A real extracted numbers
LINE B 6 random numbers

is there a command (something automatic) that can show me the longest non hit row?

Hi,

explain this a little better.  I've done a lot about this with Excel.  You want to know how many spins ago this nr showed up?

[gianfrancopierino]

i play the numbers in column B, i would like to know the lenghts of the progressions needed every time

attached in column C you have some examples, i would like to go in automatic

[Bigbroben]

A progression where you'd be at 0 or +1 on a hit?  or a softer one where it would take 2-3 or more hits to be above?

Attached are 2 sheets with your nrs and random nrs.
You can choose how many hits you want it to take to be above.  It's much softer for a prog but can end in negative territory.

Anyway, enjoy.  Enter the values you want in the blue cells.  The rest is auto calculated.

[ᶦ ᵃᵐ|Ä-łëx]

 Hi BBB..
Is there possible to make a sheet to give us an output like this every time we have a repeat...
Manual is pain..

23,12,14,5,17,12
0,32,25,36,9,25
3,18,24,3

[Bigbroben]

What do you mean?

A column where previous spins would show?  or repeaters?

yes it is possible.
send an example

[ᶦ ᵃᵐ|Ä-łëx]

Yes a column until a repeat then continue on the rest, add new numbers..

[Bigbroben]

Ok so you do NOT want to play the repeating nr, right?

[ᶦ ᵃᵐ|Ä-łëx]

No BBB i just want to get that output.. I don't care for the repeat..

[Bigbroben]

Ok.

In your scenario, the yellow-highlighted nrs that are repeating one right after the other: normal spins or you simply emphasized on these?

[ᶦ ᵃᵐ|Ä-łëx]

I just colored them so i give you to understand that i want to continue after the first set i complete ..
Lets say i input 1000 spins and i get them arrange like that..

[Bigbroben]

Like this?

Any modifications to add?