Hi there, The following is a little clunky but should work. It does not choose members randomly but just in the same order as you list them after calculating how many times each has already worked and whether they are available this week. First add an additional nine columns from K to Q with the same MD initials in row A. Then in cell K3 post the following formula. =IF(D3="YES",52-COUNTIF($C$1:$C2,D$1),0) and fill or copy across to column Q and then fill K3:Q3 down for the whole range Then in C3 paste the following formula =IF(MAX(K3:Q3)=K3,K$1,IF(MAX(K3:Q3)=L3,L$1,IF(MAX(K3:Q3)=M3,M$1,IF(MAX(K3:Q3)=N3,N$1,IF(MAX(K3:Q3)=O3,O$1,IF(MAX(K3:Q3)=P3,P$1,Q$1)))))) and fill down for your whole range. Then all that is left to do is simply choose an MD for the first week by typing in their intials to C2. I hope that helps. Let me know if you need some more info. Cheers,

Bookmarks