Random Number Generator - Multiple, Non-repeating, results
In this part of the formula...
INT(RAND()*(10-ROW()+ROW($B$2)))+1
....you probably have a line break...
INT(R
AND()*(10-ROW()+ROW($B$2)))+1
Remove it and I think you should be okay.
Hope this helps!
In article ,
A Long wrote:
I have entered the formula and checked it multiple times. However, every
time I get a message that the formula has an error. The curser moves to the
AND() every time. Should there be logical conditions within the "( )"?
Thanks
A Long
|