Need help on Excel

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

[jekhb76]

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!

[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?!?

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

[Viking64]

Variable - last 12 non blanks. I hope!