View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
A Long[_2_] A Long[_2_] is offline
external usenet poster
 
Posts: 5
Default Random Number Generator - Multiple, Non-repeating, results

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

"Domenic" wrote:

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