View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Note: RANDBETWEEN requires the Analysis ToolPak add-in be loaded.

See also JE McGimpsey's site for limitations on the RANDBETWEEN function and
workarounds to ensure you get 100 non-duplicated numbers.

http://www.mcgimpsey.com/excel/udfs/randint.html





On Tue, 14 Jun 2005 08:58:17 -0500, olasa
wrote:


You can use the =RANDBETWEEN(bottom,top)

Ola