Posted to microsoft.public.excel.worksheet.functions
|
|
Random Number Generator - Multiple, Non-repeating, results
Nevermind!
Row insertions!
Biff
"T. Valko" wrote in message
...
Why are you using this:
ROW($B$2:$B$21)-ROW($B$2)+1
Why not just:
ROW($1:$20)
Biff
"Domenic" wrote in message
...
Try the following formula, which needs to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER...
B2, copied down to B4:
=SMALL(IF(ISNA(MATCH(ROW($B$2:$B$21)-ROW($B$2)+1,$B$1:B1,0)),ROW($B$2:$B$
21)-ROW($B$2)+1),INT(RAND()*(20-ROW()+ROW($B$2)))+1)
Hope this helps!
In article ,
A Long <A wrote:
Is there a way to produce multiple, non-repeating, intergers within a
given
range?For example, generate 3 whole numbers between 1 and 20 (with an
answer
such as 4,7,18)
I need help! Thanks
|