title: How do I count how many matches from a row appear in a column in excel?
body: <p>I need to count how many <code>Secondary Names</code> repeat in the <code>Compared List</code> for each <code>Primary List</code> name. So for example: For <code>Name 1</code>, no secondary names repeat in the compared list. I would like that to show a 0% in the <code>% Match</code> column. For <code>Name 3</code>, two names in the secondary name category repeat. I would like the <code>% Match</code> to show a 66% in that column. </p>
  
  <p><a href="http://i.stack.imgur.com/3YpZD.png" rel="nofollow">Here is the snap FYR..</a></p>
  
  <p>Is there way to do it using function combination?</p>
  
  <p>Please note the actual list has ~20 secondary names for each Primary list name. There are 90 primary list names. And the compared list has 800+ names.</p>
  
  <p>Update: 
  <a href="http://i.stack.imgur.com/iZYN2.png" rel="nofollow">Format of sheet</a></p>