Sampling Without Replacement- 10 Unique Team Members from 27

I am trying to sample 10 unique team members from 27 for simulation purposes. I did it in another sheet but by creating 10 different lists, all depending on who was chosen previously and using an =RANDBETWEEN function. There must be a better way to do it as that was very time consuming- can somebody hehlp please? File is attached!

Originally Posted by alansidman

Here is a random picker I ran across last week that was developed by Crystal Long. See if this meets your needs.

IDeally avoid VBA if possible? There are further calculations I need to do for every sim of the team, and that will al lbe done in VBA- hopefully up to 20,000 times!

Originally Posted by alansidman

Here is a non VBA solution for creating a Bingo Card. I am sure that you can use this concept to develop a list of 10 from 27 that meets your needs.

I am guessing for a bingo card the probability is uniformly distributed (i.e. each of the 52 states has the same chance of being picked as another)? That is the main problem I'm facing now, as not every team member has the same chance of being picked, so writing a formula is going to be a bit tricky...

I would try something like the attached, if I'm understanding the problem correctly,

take 1 over the percentage picked and use that to base your cumulative sum on.