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