How about table with two columns in an Array:
- Column One is sequential by one - Column Two is generated by Random Number Generator with IF THEN - If Random Number Exists, reGenerate - Assign numbers to items from Column Two
Instead of an Array, create a Table to be used -- estimating length for next five to ten years
*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah https://en.wikipedia.org/wiki/Aliyah: Cincinnati to Jerusalem http://www.gojerusalem.com/items/263/German-Colony/'s German Colony https://en.wikipedia.org/wiki/German_Colony,_Jerusalem May, 2017*
*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com http://EnzerMD.com* *Publications* http://www.enzermd.com/CV.html#Publications
*If a problem has no solution, * *it may not be a problem, * *but a fact -- not to be solved, * *but to be coped with over time*
-- Shimon Peres, Ninth President of Israel
On Wed, Oct 10, 2018 at 12:25 PM Frank Cazabon frank.cazabon@gmail.com wrote:
I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcels received for the tickets issued (they keep a copy of the ticket issued to their customer and at the end of the day sort them sequentially and read the numbers off the tickets to ensure they match the parcels). They are now not wanting the number printed on the ticket as their competitors may be able to get an idea from the sequential numbers how much business they are doing (by getting a ticket early in the morning and then one ate in the afternoon).
So, they have asked me to come up with a solution and I must admit that I am coming up blank.
Any ideas?
--
Frank.
Frank Cazabon
[excessive quoting removed by server]