title: Excel Formula - Count the frequency of text values in a column
body: <p>Let's say I have different text values in a column such as:</p>
  
  <p><a href="https://i.stack.imgur.com/HQnzU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HQnzU.jpg" alt="Column A"></a><br>
  <sub>(source: <a href="http://www.sartodimoda.com/columna.jpg" rel="nofollow noreferrer">sartodimoda.com</a>)</sub>  </p>
  
  <p>I want a formula to calculate the frequency of every text value in the column.  So the answer should be displayed in two columns. Column D should be the text value and column E should be the frequency of occurrence - so it should come out something like this -</p>
  
  <p><a href="https://i.stack.imgur.com/aDsCO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aDsCO.jpg" alt="Column D &amp; E"></a><br>
  <sub>(source: <a href="http://www.sartodimoda.com/columnde.jpg" rel="nofollow noreferrer">sartodimoda.com</a>)</sub>  </p>
  
  <p>Thank you so much for your help.</p>