title: Formula to randomly assign names in a given group with Google Sheets
body: <p>I would like to create a formula in the below column <code>Assigned</code> so that a random name matching the same group as the current name is automatically inserted. </p>
  
  <p>Names in the <code>Assigned</code> column must match the group of the current name and must not repeat throughout the list. I can't assign the current name with it's own name either. Any suggestions on how to do this?</p>
  
  <p><a href="https://i.stack.imgur.com/vetFQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vetFQ.png" alt="enter image description here"></a></p>