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.