View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cderby cderby is offline
external usenet poster
 
Posts: 1
Default Unique RANDOM NUMBERS within specified range



"JE McGimpsey" wrote:

Because RAND() returns values from [0...1).

Another way, without the helper column:

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


In article ,
"Matt D Francis" wrote:

Also, don't know if this is normal but the random numbers I generate in Col
A are all decimals, why's that?