View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Non updatable Unique Random Number

I am afraid that I don't know, it has always been trial and error with me.
Perhaps someone else does know.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Herbert Seidenberg" wrote in message
oups.com...
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.