excel again :)

[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.

[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.

[Badger]

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.

[FreeRoulette]

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.

[Badger]

Thank you very much 

[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.

[Badger]

Thanks 
That is exactly what I wanted. 

[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,...

[TRD]

@BigBroben, check pm

[Bigbroben]

@ Pavkocupavko:
Here is attached the requested files.  I could not insert it in a personal message.

[pavkocupavko]

Thnak You a lot Bigbroben!


I sent you also pm.

[Badger]

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.

[Kimo Li]

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