|Posted: March 17, 2009, 8:15 am - IP Logged|
I'm looking to scramble a set of numbers and can't seem to find how to do it anywhere.
So if I have a set of numbers of say:
1 2 3 4 5 6 7 8 9 10
I would want to scramble them like this randomly:
10 1 5 9 2 6 4 8 3 7
I would need to do it for any set of numbers up to 39.
I want to play 3 sets of 11,12 & 13#'s to cover either 33,36 or all 39 digits.
I'm scrambling the #'s so I can try and get at least 4 digits to come up in one of my 3 groups. I can do it manually but it take up a lot of time and you tend to think too much on how to group them which I don't want to do. I rather scramble them and then back test the results by groups to see how many groups have 4 or more digits in them.
I tried looking for a way to do it in excel but couldn't find anything.