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

News:

Odds and payouts are different things. If either the odds or payouts don't change, then the result is the same - eventual loss.

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

Need help on Excel

Started by Bigbroben, May 11, 08:24 AM 2018

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Bigbroben

Hello,

I'm trying to figure how to add and modify automatically a group of numbers in Excel. 
Actually trying to put the numbers betted on in a bank or memory cell to compare with the next spin result.

Which function is it?

I want to have a sheet where I could only paste spin results in one column and run the Discarded game...

Thanks!
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

jekhb76

Quote from: Bigbroben on May 11, 08:24 AM 2018
Hello,

I'm trying to figure how to add and modify automatically a group of numbers in Excel. 
Actually trying to put the numbers betted on in a bank or memory cell to compare with the next spin result.

Which function is it?

I want to have a sheet where I could only paste spin results in one column and run the Discarded game...

Thanks!
Wish i could Help pal, but my excell knowledge is very Limited.

Viking64

If you send me your sheet and mockup the result you want to see, I'll see if I can help.

Bigbroben

Ok,

I want a sheet with a column to put spin results.

It would start at spin 13, when max 12 numbers appeared.
If the new spin number is not in the bank/memory, add the number to it.
If a number comes that is within the numbers in the bank, remove the oldest number from the bank.

Up to 18 nrs. When 18 fails ( no repeater when betting 18nrs), it's another story, but from 12-18 or even 1-18 is good.

I just want to know how to have a way to remember the nrs and put them in a comparative process.

Thanks!
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

holymoly

I use Google sheets (it's free)
Similar to excel
I do all my test results on GS
It's amazing
Download Google Drive too
It automatically saves everything

Good luck!

Viking64

Hi Bigroben
I wrote something for you.
Enter numbers in column A. Column C will then give you last 12 non zero numbers.
Column B makes the comparison between old and new, so don't change that.
Just drag down all three columns to enter more numbers.
Best wishes.

Bigbroben

Thanks!  I'll have a look!

No zero?!?
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

Viking64

Apologies, I should have said 'non blank' not, 'non zero'.

Bigbroben

geez!  ifindex, ifrows, iserror...

will have to study!

is it fixed last 12 or variable?

HAbS will expand from 7 to 35...
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

Viking64

Variable - last 12 non blanks. I hope!

-