Great start, but by pairing the 1's,2's,3's,etc I am left with pairing Pro's with 3 Int players and eventually there will be one Adv player on his own (which is fine, he plays California doubles for the round) So as soon as I run out of Rec players the numbers wouldn't match. I am more interested in possibly using an IF function somewhere to auto generate teams based on division (I guess?) Some logical test that would look for Pro's to go with Rec's and act accordingly when one division runs out of players and move to the next. The Rankings and random numbers being generated would probably have to be a part of this process I assume, but it's the pairings themselves that seems to be over my head-