looks like you are creating a lottery ticket number generator. You ca
use excels random generator - function : randbetween(1,56). It wil
not keep cout of previously entered numbers, but you can use othe
worksheet functions to do that. You could set 5 cells us with tha
function and have it re-run if it selects that same number twice, o
you could use excels random number generator to cycle through a list o
56 numbers and pick 5, skipping any number that has been selecte
already
