Creating an order

[Welsh Mark3]

I'm looking to create a formula that 'rank' an occurrence in the file, I guess similar to the count function but rather than the number of times it appears, I want where it appears in that range of occurrences.

[TABLE="width: 500"]
<tbody>[TR]
[TD] Column A[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Belgium[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Belgium[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]France[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]France[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]France[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Italy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Netherlands[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013 32 bit
	A	B
1	Column A	Desired Result
2	Belgium	1
3	Belgium	2
4	France	1
5	France	2
6	France	3
7	Italy	1
8	Netherlands	1
Sheet2

Cell Formulas
Range	Formula
B2	=COUNTIF(A$2:A2,A2)