0 Members and 3 Guests 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!
  • *****
  • 1126
  • Any gambling scenerio is beatable!!!
  • Rated: +41
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
  • *****
  • 647
  • Roulette Forum .cc | Lurker
  • Rated: +68
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.


Share via delicious Share via digg Share via facebook Share via linkedin Share via reddit Share via stumble Share via twitter

 

Popular pages:
  • XHTML
  • RSS
  • WAP2
Powered by SMFPacks SEO Pro Mod | Sitemap