• Welcome to #1 Roulette Forum & Message Board | www.RouletteForum.cc.

## News:

WARNING: Forums often contain bad advice & systems that aren't properly tested. Do NOT believe everything. Read these links: The Facts About What Works & Why | How To Proplerly Test Systems | The Top 5 Proven Systems | Best Honest Online Casinos

## excel again :)

Started by Stepkevh, Jul 19, 01:10 AM 2012

0 Members and 3 Guests are viewing this topic.

#### Gitano

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

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

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.

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

Quote from: Badger on 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.

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.

Thank you very much
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

#### Bigbroben

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.

Thanks
That is exactly what I wanted.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

#### Bigbroben

@ PowPow

Here is a simple setup that shows how I use simple Excel formulas.

These are good to know and had to find and learn about them by myself.  They're in column A
type in a cell: =countif (for example) a prompt explains its function and offers help.

Most of them are self-explained.
Some others aren't.
For example:
Use \$ in a formula before the Row or Column letter/nr so the reference stays the same when copying formula from one cell to another.
"" (Alt+34, alt+34): means an empty cell.  =IF (A2=""; 0; 1), for example.  It prevents also all the #VALUE! and !REF! issues

Have a look, learn... and write back when other questions arise.

If ppl do know other handy formulas, please share!

Oh yeah, just also basics:
roll the mouse on the lower right corner of a cell.  It'll show a + sign.  Click, hold and drag: it'll copy the formula to wherever you drag, from startpoint to end.  Or double-click: it'll copy the formula down the whole column until last filled cell from previous column.
It will also continued a sequence: select A1 A2 and A3 that have 1,2,3 as values.  Click hold drag: it'll do 4,5,6,7,...

Life is hard, and then you die.

#### TRD

@BigBroben, check pm

#### Bigbroben

@ Pavkocupavko:
Here is attached the requested files.  I could not insert it in a personal message.
Life is hard, and then you die.

#### pavkocupavko

Thnak You a lot Bigbroben!

I sent you also pm.

Could someone kindly help me with Excel.
I would like to track 4 streets, lets say streets 1, 2, 3, 4.

I want to play the 3 streets that came up last.
I imagine that it would be by finding the furthest street back out of streets 1,2,3,4, and playing the opposite. But I am not sure how to do that.

Any help would be appreciated.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

#### Kimo Li

Email me at roulettecirclekimoli@gmail.com and I will create one for you.

-