0 Members and 1 Guest are viewing this topic.

#### Gitano

• 100+ posts Member
• 192
• Roulette Forum .cc | Member
• Rated: +13
##### Re: excel again :)
Aug 09, 08:52 AM 2020
Hello

Good Morning All,

somebody can help me with this in excel ?

For my new idea I'm checking some spins, it is a bet selection in the roulette table..

I have a list of spins to trasform for example

1
15
23
8 <-
6 <-
8 <-
22
11
34
12
.
.
.

----> I would transform it automatically after (copy)/paste , checking every 3 spins without the repetition of a number, in this case "8" and all the list
come up.

so the new list is  :

1
15
23
8 <-
6 <-
22 <-
11
34
12
.
.
.
It is possible with a formula?
Thanks

#### Azim

• 1000+ posts member!
• 1165
• Any gambling scenerio is beatable!!!
• Rated: +49
##### Re: excel again :)
Aug 09, 09:34 AM 2020
I could be wrong, not possible with formula but macro yes. Or we could leave a blank cell between numbers.

1
15
23
8 <-
6 <-

22
11
34
12
Like this.
With right tools and good money management, any gambling activity can produce a steady income.

#### ati

• 500+ posts Member
• 743
• Roulette Forum .cc | Lurker
• Rated: +85
##### Re: excel again :)
Aug 09, 09:54 AM 2020
In such cases I always write a simple formula (or more if needed), apply the right filters and delete the unwanted rows.

For example, if you have a list of spins in column A, type the following into the B3 cell: =IF(OR(A3=A1,A3=A2,A2=A1),1,))

If you there is a repeat, it will show "1", otherwise FALSE. Filter down to 1's in column B and delete all rows.

• 100+ posts Member
• 157
• Rated: +7
##### Re: excel again :)
Dec 13, 12:41 PM 2021
Could someone kindly help me with Excel coding.

I am trying to look for a repeat in previous spins.
So on spin 2, I check spin 1
On spin 3, I check spin 1,2
On spin 4, I check spins 1,2,3 etc
Once a cycle closes, I want to start over with the next cycle.
Is there a simple formula I could use?

I have attached an excel sheet to explain what I am trying to do.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

#### FreeRoulette

• 250+ posts Member
• 401
• Rated: +31
##### Re: excel again :)
Dec 13, 12:50 PM 2021
Could someone kindly help me with Excel coding.

I am trying to look for a repeat in previous spins.
So on spin 2, I check spin 1
On spin 3, I check spin 1,2
On spin 4, I check spins 1,2,3 etc
Once a cycle closes, I want to start over with the next cycle.
Is there a simple formula I could use?

I have attached an excel sheet to explain what I am trying to do.

I added a count column. The formula is like this =COUNTIF(\$B\$4:B5,B5)

When you start over with a new cycle, just change the static cell from \$B\$4 to the starting cell.
Get free crypto coins  https://tinyurl.com/tvh7f65

• 100+ posts Member
• 157
• Rated: +7
##### Re: excel again :)
Dec 13, 01:21 PM 2021
Thank you very much
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

#### Bigbroben

• 1500+ posts member!
• 1600
• Member
• Rated: +167
##### Re: excel again :)
Jan 05, 04:13 PM 2022
Pimped.  Used the OFFSET function to have the reference valid down the spins, instead of restarting all the time.

Further right: Spin gaps between hits and stats.

Life is hard, and then you die.