title: How to count the number of times text is repeated
body: <p>I have a data like</p>
  
  <p>A<br>
  B<br>
  A<br>
  D<br>
  C<br>
  E<br>
  C<br>
  A  </p>
  
  <p>I want that when A is repeated I get the number of time(freqency) it gets repeated.
  So data set should read like this
  A 1<br>
  B 1<br>
  A 2<br>
  D 1<br>
  C 1<br>
  E 1<br>
  C 2<br>
  A 3   </p>
  
  <p>I need to know a formula which can help me identify the count beside the text and nth number of time it got repeated.</p>