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.

*

Badger

  • 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

*

Badger

  • 100+ posts Member
  • ***
  • 157
  • Rated: +7
Re: excel again :)
Dec 13, 01:21 PM 2021
Thank you very much  :) :thumbsup:
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.
Mes pensées sont le dernier retranchement de ma liberté.

*

Badger

  • 100+ posts Member
  • ***
  • 157
  • Rated: +7
Re: excel again :)
Jan 07, 07:14 AM 2022
Thanks 
That is exactly what I wanted.  :)
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.