List manipulation, how to change the starting point in a list of set numbers

Which wheel type are we talking about?

Single-zero wheel
0-32-15-19-4-21-2-25-17-34-6-27-13-36-11-30-8-23-10-5-24-16-33-1-20-14-31-9-22-18-29-7-28-12-35-3-26

Double-zero wheel
0-28-9-26-30-11-7-20-32-17-5-22-34-15-3-24-36-13-1-00-27-10-25-29-12-8-19-31-18-6-21-33-16-4-23-35-14-2

Triple-zero wheel
0-000-00-32-15-19-4-21-2-25-17-34-6-27-13-36-11-30-8-23-10-5-24-16-33-1-20-14-31-9-22-18-29-7-28-12-35-3-26

Whichever wheel type you are talking about.

Lets assume single zero
Surely if you create an array listing the sequence twice

0, 32, 15, 19, 4, 21, 2, 25, 17, 34, 6, 27, 13, 36, 11, 30, 8, 23, 10, 5, 24, 16, 33, 1, 20, 14, 31, 9, 22, 18, 29, 7, 28, 12, 35, 3, 26, 0, 32, 15, 19, 4, 21, 2, 25, 17, 34, 6, 27, 13, 36, 11, 30, 8, 23, 10, 5, 24, 16, 33, 1, 20, 14, 31, 9, 22, 18, 29, 7, 28, 12, 35, 3, 26

If your last number is 15

Use RandBetween to return a number between 0 and 36

Lets Assume 9

Use Match to find 15 in your array

=MATCH(15,{0,32,15,19,4,21,2,25,17,34,6,27,13,36,11,30,8,23,10,5,24,16,33,1,20,14,31,9,22,18,29,7,28,12,35,3,26,0,32,15,19,4,21,2,25,17,34,6,27,13,36,11,30,8,23,10,5,24,16,33,1,20,14,31,9,22,18,29,7,28,12,35,3,26},0)

=3

use Choose to select your new number which will be 3+9 from the start = 27

=CHOOSE(13,0, 32, 15, 19, 4, 21, 2, 25, 17, 34, 6, 27, 13, 36, 11, 30, 8, 23, 10, 5, 24, 16, 33, 1, 20, 14, 31, 9, 22, 18, 29, 7, 28, 12, 35, 3, 26, 0, 32, 15, 19, 4, 21, 2, 25, 17, 34, 6, 27, 13, 36, 11, 30, 8, 23, 10, 5, 24, 16, 33, 1, 20, 14, 31, 9, 22, 18, 29, 7, 28, 12, 35, 3, 26)

Returns 27

@Harri05,

I think you are making this too hard for yourself. If you are picking the number from the list using a random index number (which without being able to see your code, that is what I assume you are doing), why do you think you have to change the order of the list? A random index number is a random index number... the order of the list it is picking from is immaterial. Just leave the list as is and let the random number generate pick a number from it randomly.

I assume what you mean is: a number comes up, you pass that to a function to re-arrange the list of numbers now beginning that came up on the last "spin". If so, this might do what you want:

Please Login or Register  to view this content.

That's assuming your number list is in column "A", starting in A1. Also, although it's a "numbers" list, they need to be entered as text to avoid "00" showing as "0" etc.

Assuming the number 15 comes up... you call the function with revolve_list("15") and, hey presto, your list has spun itself round.

See attached.

I've attached another copy that demonstrates. Have a look at the code that the button calls (the assigned macro) so you can see what's going on.

Please Login or Register  to view this content.

Tim

Originally Posted by Fluff13

You can use a formula as well

I wasn't sure if the OP just wanted the count difference or if he actually wanted to see the "revolved" "wheel" numbers. I assumed he wanted the count difference only; hence, the function that I posted.

Another way to see the revolved wheel numbers is to use a macro to "revolve" them in place. Lets say the "wheel" numbers are in cells A1 through A38. Since I am assuming a roulette wheel, those cells must be formatted as Text so that "00" does not become "0" due to Excel's "helpfulness". This code will revolve them in place by placing the new number entered into the InputBox at cell A1...

Please Login or Register  to view this content.

Originally Posted by Fluff13

Along with the comments by Rick, try entering 1 as the start number

Ooops. That's no good! Cludge:

Please Login or Register  to view this content.

Doesn't resolve the Exel 2010 issue, though. I *think* this does

Please Login or Register  to view this content.

However, I feel I'm clutching at straws... getting my concept to work when others' is more elegant! Thanks for pointing out my errors!

Tim