title: Excel counts the number of times a value appears in a group of columns but counts only one instance of the name per row
body: <p>I need to find the number of times a name appears on this list but I only want to count one instance of the name one time for each row without counting the duplicate name in the row. </p>
  
  <p>For instance: I have the following in a range...</p>
  
  <pre><code>Red     Bill    Jack    Ruby    Bill
  Blue    Ruby    Ivan    Raul    Ted
  Green   Ted     James   Rick    Ted
  Red     Ted     Phil    Ruby    Bill
  </code></pre>
  
  <p>And in this worksheet, I want to count the number of instances of the name Bill and get the answer of 2 because Bill's name shows up in two rows. In the same respect, If I choose to count the name Ted, the answer should be 3 because Ted's name shows up in three rows.</p>