Need to Random Pick Names but exclude certain ones - Please help!

[ReginaJ]

I have created a list of names on Sheet 1 in column A, but if they have been terminated there is a date in column D. Now I want to schedule random screening of the current names - Need to exlude anyone that has a date listed in column D. (This will be on a second Sheet.) I have figured out how to make it pick one random name by using the following:
=INDEX(DRIVERS!$A:$A,RANDBETWEEN(2,COUNTA(DRIVERS!$A2:$A5000)),1)

How do I make it exclude names in column A if they have a date listed in column D?

Also, I want to make it pick more than one name - Is this possible or do I just have to paste this formula into the number of needed cells?

 

[Domenic]

Try...

F2:

=SUMPRODUCT(--(A2:A5000<>""),--(D2:D5000=""))

G2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(ROWS(G$2:G2)<=$F$2,INDEX($A$2:$A$5000,SMALL(IF(ISNA(MATCH($A$2:$A$5000,$G$1:G1,0)),IF($A$2:$A$5000<>"",IF($D$2:$D$5000="",ROW($A$2:$A$5000)-ROW($A$2)+1))),INT(RAND()*($F$2-(ROWS(G$2:G2)-1)))+1)),"")

Hope this helps!