I am struggling and hoping someone is able to help.
I am trying to make a list where the next number in the list is based off the number before it. Specifically, I have three numbers (1,2,3), and I want the next number in the sequence not to be the previous number, and random between the other two. I also want this to stop at a specific number, and I think I have that part figured out.
My thinking is that I use 'List.LastItem" to get the last number in the list and plug that into ‘SetDifference’ to find the two numbers not used and then shuffle and grab the first number. Then with that number add it to the end of the list with LoopWhile. There seems to be some disconnect and I am thinking it is because I did not set up the function correctly.
Any thing you can do to help is much appreciated!