How do I count how many matches from a row appear in a column in excel?
<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>