Random Number Generator - Multiple, Non-repeating, results
Try...
B2, copied down:
=SMALL(IF(ISNA(MATCH(ROW($B$10:$B$19),$B$1:B1,0)), ROW($B$10:$B$19)),INT(R
AND()*(10-ROW()+ROW($B$2)))+1)
....confirmed with CONTROL+SHIFT+ENTER.
Hope this helps!
In article ,
A Long wrote:
I got it to work for the range 1-20, but am not sure what to change in the
formula to make the range 10-19. Sorry to be a bother and a dummy.
Thanks
A Long
|