Forum Discussion
How should I write this Process?
I am not sure how to do this in function for without going through a long chain of manual brute force steps and hope I'm in the right discussion group for this. I have hunted the help hits on my sea...
I agree with mathetes. At the very least we may help you do whatever you are ultimately trying to do better. but i believe you want a function to give you an array of rand numbers for each row/person where the 'chances' are the number of elements in the array for that row. Basically you want RANDARRAY()
=RANDARRAY(1,C5,1,100,1)I'm not sure what you are hoping for with the red and blue.
On another note, the problem with random numbers in excel is that they will change every time you do anything on the sheet. so if you want to document the result you will need to take a screen shot or copy and then paste values only to lock the values