G'Day,

I'm using the following formula to randomly select 1 candidate from a list of names.

=INDEX(B5:B255,RANDBETWEEN(1,COUNTA(B5:B255)),1)

My problem is I need to select up to 10 candidates and repeating this formula 10 times can select the same candidate twice, sometimes thrice.

Is there a method I can use that will exclude a previously selected candidate, and then randomly select from the remainder - up to 10 times?

Thank you in advance.