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

Sr no	year	name	clean_name	unique_id
1	2002	YOON, ALBERT,	YOON, ALBERT	1
2	2003	YOON, ALBERT,	YOON, ALBERT	1
3	2004	YOON, ALBERT,	YOON, ALBERT	1
4	2005	YOON, ALBERT,*	YOON, ALBERT	1
5	2006	YOON, ALBERT H.,	YOON, ALBERT	1
6	2007	YOON, ALBERT H.,	YOON, ALBERT	1
7	2008	YOON, ALBERT H.,	YOON, ALBERT	1
8	1980	WARREN, ELIZABETH,	WARREN, ELIZABETH	2
9	1981	WARREN, ELIZABETH,	WARREN, ELIZABETH	2
10	1983	WARREN, ELIZABETH,	WARREN, ELIZABETH	2
11	1984	WARREN, ELIZABETH,	WARREN, ELIZABETH	2
12	1985	WARREN, ELIZABETH,	WARREN, ELIZABETH	2
13	1987	WARREN, ELIZABETH, F	WARREN, ELIZABETH	2

<colgroup><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>

 

[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.