title: Formula to count members in a list with Google Spreadsheets
body: <p>I have a Google Spreadsheet with a set of data that looks like this:</p>
  
  <pre><code> A  | B             | C  | D
  --------------------------------
   .. | John Smith    | .. | 2011
   .. | john smith    | .. | 2011
   .. | Kathy Ericson | .. | 2012
   .. | JOHN SMITH    | .. | 2013
   .. | Kathy Ericson | .. | 2012
  </code></pre>
  
  <p>What I would like to do is count each unique person (John Smith/john smith, 2011 is NOT the same as JOHN SMITH, 2013) and display in column E how often that person shows up in the list. In this example:</p>
  
  <pre><code> A  | B             | C  | D    | E
  --------------------------------------
   .. | John Smith    | .. | 2011 | 2
   .. | john smith    | .. | 2011 | 2
   .. | Kathy Ericson | .. | 2012 | 2
   .. | JOHN SMITH    | .. | 2013 | 1
   .. | Kathy Ericson | .. | 2012 | 2
  </code></pre>
  
  <p>How would I go about creating a formula that could do that? I have basic knowledge of Excel formulas, so perhaps a VLOOKUP?</p>