Numbering Tickets

  • Thread starter Thread starter Dan Tschippert
  • Start date Start date
D

Dan Tschippert

I need a routine to put numbers on a ticket.

The numbers would be from 000 to 999. There would be 4 numbers on each
ticket and the same numbers would be repeated on the ticket stub.

Obviously the numbers can't repeat from 000 to 999.

Any suggestions?

Thanks, in advance.
 
How do you determine what 4 numbers go on each ticket? Is it entirely
random, or is there some logic or sequence to it?
 
The numbers are random on each ticket, but can not repeat through the 250
tickets (other than the two places on the ticket itself).
 
Dan said:
I need a routine to put numbers on a ticket.

The numbers would be from 000 to 999. There would be 4 numbers on each
ticket and the same numbers would be repeated on the ticket stub.

Obviously the numbers can't repeat from 000 to 999.

Any suggestions?

Thanks, in advance.
Click to expand...

Create two columns, one with the numbers from 000 to 999, and the other
with the rand() function. Then sort by the column with the rand()
function. Every time you sort it, you'll get a different result.
 
Back
Top