Unique Code for Same Names Appearing in a Column

[manoj18071965]

I have an excel where in D column Same name are appearing multiple times. They are already grouped I just need to provide unique_id code (1, 2, 3...) for each group as shown in below example in column E:

Col A Col B Col C Col D Col E
[TABLE="width: 486"]
<colgroup><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]Sr no[/TD]
[TD]year[/TD]
[TD]name[/TD]
[TD]clean_name[/TD]
[TD]unique_id[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]2002[/TD]
[TD]YOON, ALBERT,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]2003[/TD]
[TD]YOON, ALBERT,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]2004[/TD]
[TD]YOON, ALBERT,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]2005[/TD]
[TD]YOON, ALBERT,*[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]2006[/TD]
[TD]YOON, ALBERT H.,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]2007[/TD]
[TD]YOON, ALBERT H.,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]2008[/TD]
[TD]YOON, ALBERT H.,[/TD]
[TD]YOON, ALBERT[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]1980[/TD]
[TD]WARREN, ELIZABETH,[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]1981[/TD]
[TD]WARREN, ELIZABETH,[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]1983[/TD]
[TD]WARREN, ELIZABETH,[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1984[/TD]
[TD]WARREN, ELIZABETH,[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]1985[/TD]
[TD]WARREN, ELIZABETH,[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]1987[/TD]
[TD]WARREN, ELIZABETH, F[/TD]
[TD]WARREN, ELIZABETH[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Assuming that this is going in column D, and the first line of data is row 2 (header in row 1), place a 1 in cell E2, and then place the following formula in cell E3 and copy down for all rows:

=IF(D3=D2,E2,E2+1)

 

[manoj18071965]

In provided example i inserted 1 & 2 values in column E manually. I want this value to be populated with formula

 

[Joe4]

In provided example i inserted 1 & 2 values in column E manually. I want this value to be populated with formula

Did not see the formula I provided above?
If you do not like having to place a 1 in the first cell only (E2), you could use this formula in all cells instead:

=IF(ROW()=2,1,IF(D2=D1,E1,E1+1))

 

[manoj18071965]

Thank you so much! It works now...

 

[Joe4]

You are welcome.