Thread: Random gen
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Random gen

Why not divide up your values to correspond to the date and time or think up
an algorithm that would generate an id based on the date and time. Then you
would be sure it is unique.

--
Regards,
Tom Ogilvy

"pauluk " wrote in message
...
hi all,

ok what am looking to do is create a random unique id from a set list
of characters the characters range A1:A37 the length of the id is
shortest 5 and longest 12

Thanks in advance


---
Message posted from http://www.ExcelForum.com/