Concatenate + Count if with a dynamic range
<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>