I have a list of 50 names and need to pick 10 of those names at random. Each name can be picked only once. Can you please help me out with the code for this. I have experimented with =Rand() with no luck and =INDEX($A$1:$A$50,RANK(C1,$C$1:$C$10)) with no luck. I have also tried =INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))). I must be missing something.
All names are in A1:A20 and I would like to display the 10 randomly picked names in C1:C10.
Thanks
All names are in A1:A20 and I would like to display the 10 randomly picked names in C1:C10.
Thanks