I am attempting to create a sheet that reads a cell and generates a set of random numbers based on that cell's length
I have a long list of one to four random numbers, in the format below.
4 2 2 0 4 4 0 0 3 1 0 0 0 4 4 0 0 0 3 0 0 1 2 2 0 0
One of these numbers will be picked at random by another process. I need to generate another random number between 1-4 for each of those numbers. If three numbers are chosen, I need to generate three more numbers. If only one number is chosen, then I need to generate one more number.
I'm not sure how to do this, as I don't appear to be able to use more than one RANDBETWEEN per cell.