Put the persons name in a column for the number of tickets they have bought.
Use the formula in post #9. Press F9 to refresh the calc and get another name.
ie:
bloggs
bloggs
bloggs
white
white
white
Alternatively, use the barrel (for the tickets, that is