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