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.
--
barrfly
Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile:
http://www.excelforum.com/member.php...fo&userid=4141
View this thread:
http://www.excelforum.com/showthread...hreadid=468342