I have looked at the random functions of Excel and downloaded the random generator, but what I am trying to do is display a name to make it easier on the night.
Ideally what I would like to do is have a list/number of how many tickets a person has bought. This would then be placed in a spreadsheet with all other ticket buyers, a calculation would then display the name of the person who wins each "draw", the draw would occur for the number of prizes.
Otherwise I will go old school with tickets in a barrel.