• 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

Main Menu
Popular pages:

Roulette System

The Roulette Systems That Really Work

Roulette Computers

Hidden Electronics That Predict Spins

Roulette Strategy

Why Roulette Betting Strategies Lose

Roulette System

The Honest Live Online Roulette Casinos

excel again :)

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

Previous topic - Next topic

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.

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.
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.
Get free crypto coins  link:s://tinyurl.com/tvh7f65

Badger

Thank you very much  :) :thumbsup:
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.
Mes pensées sont le dernier retranchement de ma liberté.

Badger

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.
Mes pensées sont le dernier retranchement de ma liberté.

TRD

@BigBroben, check pm

-