Adding Text To Second Duplicate

[Gamermatt]

Hello,

I have a list of product numbers in column A. Some of them have duplicates, or even triplicates. I need to add "-2" to the end of the product number if it is the second instance of the number, and "-3" if it is the third instance of the number. How would I go about doing this?

Matt

 

[danzon]

how about

with data starting in A1 and going thru A10

in B1 enter
=A1

in B2 enter
=IF(COUNTIF(A2:A$10,A2)<2,A2,A2&"-"&COUNTIF(A2:A$10,A2)) and drag down

 

[danzon]

a little better I think

in B1 and drag down

=IF(COUNTIF(A$1:A1,A1)<2,A1,A1&"-"&COUNTIF(A$1:A1,A1))

 

[Gamermatt]

how about

with data starting in A1 and going thru A10

in B1 enter
=A1

in B2 enter
=IF(COUNTIF(A2:A$10,A2)<2,A2,A2&"-"&COUNTIF(A2:A$10,A2)) and drag down

Thank you Dan, works like a charm