title: List and count values in an Excel Spreadsheet
body: <p>I have an excel worksheet organized in the following manner  </p>
  
  <p>Columns H to AK <code>(named "Roadshow City 1, Roadshow City 2, through to Roadshow City 30)</code> containing the names of a particular city</p>
  
  <p>I need to list the names of each city and count how many times they appear in the column range.  Essentially, I would like the result to look like </p>
  
  <pre><code>New York  23
  San Francisco  15
  London  12
  etc
  </code></pre>
  
  <p>At the moment, I have typed the name of each city on another tab (by eyeballing each column) and then used the following formula to count them - for example for New York</p>
  
  <pre><code>=COUNTIF('IR Firms Registered on FUNDEXA'!$H$4:$AK$114,A2).  A2 being the cell in which I have typed "New York" 
  </code></pre>
  
  <p>Is there way to dynamically update this list so that it automatically adds to the list if a new city appears and/or count each additional instance of when a city name appears in the column range.</p>
  
  <p>Is it possible to do this with a formula or pivot table (rather than macro code).  I have a very limited understanding of macro coding.</p>
  
  <p>I am happy to take suggestion from experts on how to reorganize or restructure the data to make it easier to list and count.</p>