Counting and numbering range of text : <p>I am after a clever combination of Excel formulas that will be able to produce what I have manually typed into the yellow highlighted boxes on the screenshot.</p>

<p>What I need to produce is essentially, for the range of months on the far right column, to count each instance of it and order each one starting with 1 and incrementing by 1 until it changes to the next month. </p>

<p><a href="https://i.stack.imgur.com/gmKLY.png" rel="nofollow noreferrer">Screeshot example</a></p>

<p>I'm wondering if someone has in their brain a nice combination of nested formulas or something similar ready to go they could enlighten me with?</p>

<p>Much appreciated.</p>
