title: Create a sequence column in Excel
body: <p>I have a column with names and i wanted to add a column that count the sequence of each row based on the name. So if a name appears multiple time (i.e 4), the first row of that name will have sequence 1 and the 2nd row sequence 2, etc...</p>
  
  <pre><code>Name        Sequence    
  Andrew       1    
  Andrew       2    
  Andrew       3    
  Paul         1    
  Amy          1    
  Amy          2    
  Jean         1
  </code></pre>