title: How to check if a value is partial, full, or none based on multiple values
body: <p>I have a column of names and a column called is broke rules.</p>
  <ul>
  <li>If the person has both broken the rule at lease once and also followed the rule at least once = <code>partial</code></li>
  <li>If a person has always broken the rule = <code>rule breaker</code></li>
  <li>If a person has always followed the rule = <code>rule follower</code></li>
  </ul>
  <p>I know how I would do this programmatically in python or something, but how do I check their actual rule breaking status in excel?</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>broke rule</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>bob</td>
  <td>no</td>
  </tr>
  <tr>
  <td>bob</td>
  <td>no</td>
  </tr>
  <tr>
  <td>jane</td>
  <td>no</td>
  </tr>
  <tr>
  <td>sam</td>
  <td>yes</td>
  </tr>
  <tr>
  <td>jane</td>
  <td>yes</td>
  </tr>
  <tr>
  <td>jake</td>
  <td>no</td>
  </tr>
  <tr>
  <td>bob</td>
  <td>yes</td>
  </tr>
  <tr>
  <td>paul</td>
  <td>no</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The result I want</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>broke rule</th>
  <th>rule breaking status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>bob</td>
  <td>no</td>
  <td>partial</td>
  </tr>
  <tr>
  <td>bob</td>
  <td>no</td>
  <td>partial</td>
  </tr>
  <tr>
  <td>jane</td>
  <td>yes</td>
  <td>rule breaker</td>
  </tr>
  <tr>
  <td>sam</td>
  <td>yes</td>
  <td>rule breaker</td>
  </tr>
  <tr>
  <td>jane</td>
  <td>yes</td>
  <td>rule breaker</td>
  </tr>
  <tr>
  <td>jake</td>
  <td>no</td>
  <td>rule follower</td>
  </tr>
  <tr>
  <td>bob</td>
  <td>yes</td>
  <td>partial</td>
  </tr>
  <tr>
  <td>paul</td>
  <td>no</td>
  <td>rule follower</td>
  </tr>
  <tr>
  <td>jake</td>
  <td>no</td>
  <td>rule follower</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have this formula but it only tells me if the are a <code>rule follower</code> or have broken the rule at least once.</p>
  <pre><code>=IF(COUNTIFS(A:A,A2,B:B,&quot;No&quot;),&quot;Broken rule at least once&quot;,&quot;Rule follower&quot;)
  </code></pre>