Im trying to make a pick names at random from a list on excel Column A to C. but I don't want them to repeat once they are chosen how do I do that? Or can it be done? I have this formula
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
and also the column B shouldn't be selected by employee more than 2 people. what formula I used to stop selecting from more that 2 names on column B form column A
Bookmarks