title: Building a random name generator with no duplicates
body: <p>I am currently assigning members of my organization to meet with other perspective members. I have three criteria:</p>
  
  <ol>
  <li>Every perspective member must meet with 6 different current members</li>
  <li>No current member can member with the same perspective member twice</li>
  <li>The pairings must be random</li>
  </ol>
  
  <p>I've tried the random name/number generator in Excel:</p>
  
  <pre><code>=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1) 
  </code></pre>
  
  <p>...and while useful, it didn't ensure that each perspective met with 6 different current members or that no current met with someone twice.</p>
  
  <p>I have also added a diagram, I imagine the red to be perspective members, blue is current members, and the green is where I'd sort the pairs (based on current members).</p>
  
  <p><img src="https://i.stack.imgur.com/Luamr.png" alt="Screenshot"></p>
  
  <p>Please help me, I'm totally at a loss for how to do this. </p>