I WOULD LIKE HELP ON FORMULATING DATA ON EXCEL THAT WOULD EXECUTE
RANDOM NUMBERS WITHOUT REPEATING. I TRIED USING THE FOLLOWING FORMULA
BUT IT REPEATS SOME OF THE NUMBERS: =RAND()*39. ONCE I ENTER THIS
FORMULA A NUMBER SHOWS UP ON CELL A1 AND THEN I JUST DRAG TO OTHER
CELLS AND EXCEL AUTOMATICALLY GENERATES OTHER NUMBERS BUT REPEATS SOME
OF THEM. I NEED HELP SO THAT IT DOES'NT REPEAT THEM . THANKS. AL.
=================================================================
Instructions for joining and leaving this list and remarks about
the problem of INAPPROPRIATE MESSAGES are available at
http://jse.stat.ncsu.edu/
=================================================================
