Annex file is an example...

Each participant have a unique number (1000 => 1060).
The participant receive for each serie a number of a ticket.

BUT.
The participant may never get the same batch number assigned.

I search a macro that give the participants a ticket for the serie (random assigned).


Thanks
Random.xls