Tried to add a "-" simple when adding a digit to a series

[Groovicles]

Hi everyone,

I have the following code which adds a consecutive digit to a repeating cell value in:

=a2&countif($A$2:A2,A2)

So, this formula has put in cell B2. This means, that if if A2:A5=1 for each row, then B2=11, B3=12, B4=13, etc.

What I'm trying to do is put "-" between the original value and the extra digit. So, B2 would instead look like 1-1, B3=1-2, B4=1-3, etc.

Any ideas how I can do this?

Thanks!!

[benishiryo]

hi Groovicles. maybe:
=A2&"-"&COUNTIF($A$2:A2,A2)

[Groovicles]

Ben. You, sir, are a genius. Thanks!