View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Non updatable Unique Random Number

What is the relationship between the number of records
and the number of iterations I have to do?
I tried 400 records and, in the formula, changed 2000 to 400.
I had to iterate 625 times before the numbers became unique.