Does the rand function throw out previous samples or put them back?
I have a user that is using =rand()<0.10+0*now() to pull a sample. A bookmark was created and turned into a button to select the sample. What we are wanting to know is that if the button is clicked more than once, does the previous sample get thrown out or does it throw all selections back in and select another random sample?
I am not sure if I understood what you are asking but as far as I know, RAND() will not throw out previous samples, so there is a likelyhood to get the same value twice returned from RAND().
