I am trying to produce a random number from numbers not yet drawn from a pick 4 list of previously drawn numbers. So I want it to produce a random number between 0000 and 9999 and then check it agaist my list of previously drawn number in column c. If the random number picked is in the list then pick another number until it selects one that was not previously drawn. I figured out I could use Randbetween to generate my number but I am having trouble having that number check against the list and if it finds the number reselect another number until it get a number not previously drawn from the list. Try to make the solution as simple as possible.
Thanks In advance
Thanks In advance