Lucky Draw Number with Excel
This simple formula works for both names and numbers. You just need to enter all eligible person name or numbers in column A. This formula able give you new draw after pressing F9 (calculate now button).
=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A)))