Can excel be used to create a random number generator?

[comotoman]

numbers ranging from 1-56, 5 places, and no 2 numbers the same. then 1-56, 1 place

[barrfly]

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

[comotoman]

if i win ill let you know