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!
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.
If you send me your sheet and mockup the result you want to see, I'll see if I can help.
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!
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!
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.
Thanks! I'll have a look!
No zero?!?
Apologies, I should have said 'non blank' not, 'non zero'.
geez! ifindex, ifrows, iserror...
will have to study!
is it fixed last 12 or variable?
HAbS will expand from 7 to 35...
Variable - last 12 non blanks. I hope!