Excel: Combining first come first served with random selection from a waiting list.

I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking [I]n[/I] people per year to join. However, we don't want this done on a first-come-first-served basis, nor do we want an entirely randomised selection, rather a combination of the two where the probability of being picked at random increases linearly with increasing time on the waiting list i.e. someone that has been on the waiting list for longer will be more likely to be picked than someone who has recently joined, though some chance remains for someone new to the waiting list to be picked. Any suggestions on how to model this in Excel? Fairly proficient user, so nothing off limits! Thanks in advance, Rory

This question generated 6 answers. To proceed to the answers, click here.

This thread is current as of March 18, 2018.

For more resources for Microsoft Excel