title: Excel - determining frequency of a non-numerical result in a single column of data
body: <p>I have been looking at the answer to this question and need a bit of further detail. </p>
  
  <p><a href="https://stackoverflow.com/questions/5972947/frequency-of-strings-in-an-excel-column-pretty-sure-this-requires-vbscript/6482519#6482519">https://stackoverflow.com/questions/5972947/frequency-of-strings-in-an-excel-column-pretty-sure-this-requires-vbscript/6482519#6482519</a></p>
  
  <p>I see answer No. 2, by Chris Neilsen, uses a pivot table to determine the count of each result in the name column. Two questions, how is the "count of name" column produced in the pivot table? Secondly, if another name is added after the pivot table is created, (ie, add Sarah to cell A9), will the table automatically update?</p>
  
  <p>I have a single column of non-numerical data that will be updated regularly. I am having difficulty creating a summary of the data showing the frequency of each result, with the stipulation that the summary will also update when items are added to the list. It seems a Pivot Table is the best solution, but I am open to other suggestions.</p>