Applying Formula to assign numeric values to text values in sequential order

http://www.excelforum.com/showthread...5&goto=newpost

I want to achieve a similar objective, but when I insert the formula, it will not insert a number to a respective duplicate value.

After inserting the formula =if(COUNTIF(H$2:H2,H2)=1,MAX(I$1:I1)+1,VLOOKUP(H2,H$1:I1,0,FALSE))

It returns:

H~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~I
Heat#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Blank)
HT 414... Unique~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1
HT D07... Unique~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2
HT C21... Unique~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3
HT 414... Duplicate of first Unique Value~~~~~~~~~~~~~~~~(Blank)
HT 234... Unique~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4

My question is how do I get the duplicates to show the value given to the original unique value so that, in this example, the second and subsequent HT 414... will show 1 and so on for all possible duplicates.

For instance, if HT C21 reappears, the adjacent cell will return "3"

Thank you in advance.

That did it!

Thanks