title: Concatenate + Count if with a dynamic range
body: <p>I need to write this on the second line of the first column (A2) and then autofill until the end of the spreedsheet.  </p>
  
  <p><code>=CONCATENATE(D1;".";COUNTIF($D$1:D1, D1))</code></p>
  
  <p>The fisrt "D1" needs to be fix, because on the second line the code must be "<code>=CONCATENATE(D1;".";COUNTIF($D$1:D2, D2))</code>" </p>
  
  <p>Its a large amount of data and Excel wont handle it by formula, so I need to do it with VBA. </p>
  
  <p>What I'm trying to do: </p>
  
  <p>I have a list of names that appear more than once. I need the name to be written with the number of times it has appeared so far. For example:</p>
  
  <pre><code>Miriam  -- Miriam.1
  Maria   -- Maria.1
  Thiago  -- Thiago.1
  Maria   -- Maria.2
  Cloe    -- Cloe.1
  Maria   -- Maria.3
  </code></pre>
  
  <p>Can anyone help me, please?</p>