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.

### Similar Topics

###### Excel bot

Started by Stepkevh on Roulette Software

11 Replies
8911 Views
Last post: Dec 09, 05:35 AM 2012
by
Stepkevh

Started by Kav on Coding for Roulette

1 Replies
3356 Views
Last post: May 02, 04:54 PM 2010
by
VLS
###### Excel Help.....

Started by ddarko on Main Roulette Board

9 Replies
2849 Views
Last post: Aug 15, 06:59 PM 2015
by
sniper
###### Need help on Excel

Started by Bigbroben on Testing zone

9 Replies
1189 Views
Last post: May 13, 09:07 AM 2018
by
Viking64

Popular pages: