Create ID for duplicate values

[Welsh Mark3]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Col A[/TD]
[TD]Desired Result[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rich[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rich[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to create a formula that gives an incremental numerical value for duplicate values? My actual spread sheet will be bigger than the example above.

 

[VBA Geek]

one way:

<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B2</th><td style="text-align:left">=IF(<font color="Blue">ISNA(<font color="Red">MATCH(<font color="Green">A2,A$1:A1,0</font>)</font>),MAX(<font color="Red">B$1:B1</font>)+1,VLOOKUP(<font color="Red">A2,A$1:B1,2,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

Excel 2013/2016
	A	B
1	Name	ID
2	Mark	1
3	Mark	1
4	Rich	2
5	John	3
6	Rich	2
7	John	3
Sheet2