Hello All,

I'm an IT Director and I'm working on a spreadsheet that will randomize employee numbers (1 through 29) so that I can do truly random audits.

In F11, I'm currently using =RANDBETWEEN(1,29) which generates the random employee number I need when I press the F9 function key. What I want to do now is remove certain numbers from being a result.

Those numbers I want excluded will be listed in J16, J17, J18, J19, J20, J21, J22, J23, J24, J25, J26 and J27.

Each of those locations can contain more than one number seperated by a comma. So J17 may have employee numbers 1, 17, 13 ... like so...

Basically, I'm going to hit F9 three times per month to generate employee numbers to audit and then I'll enter those results in a "Done" column listed for each month (J16 through J27) and I want those excluded from future random results.

I'll zip up the spreadsheet I've done so far if it helps to explain what I'm talking about here. I've added 3 supposed results for January, I would need those and all cells below that down to J27 included in the "exclude" part of the formula

Any help would be greatly appreaciated. I am really weak with Excel and I've been working on that. Just not quite there yet. Thanks guys!