or create a GUID for each item, bit long, but un ique.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tom Ogilvy" wrote in message
...
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/