Create unique ID based off of adjacent cell

[kod2th3e]

I am trying to use a forumla to look at the value in column b then create a unique id in column a based off of that value. In the table below I have a 3 digit value (in column B) that may be repeated any given number of times and if so I want the corresponding text in column "A" to equal that value with a "-1", "-2", etc after it depending how how many times the number has been repeated. Thanks in advance for any/all help.

Col A	Col B
114-1	114
114-2	114
114-3	114
114-4	114
115-1	115
115-2	115
116-1	116
116-2	116
116-3	116

<tbody>
</tbody>

 

[Joe4]

Assuming your data begins in row 1, place this formula in cell A1 and copy down:

=B1 & "-" & COUNTIF(B$1:B1,B1)

 

[kod2th3e]

Joe,

Perfecto! That's just what I was looking for, thanks again for the help.

 

[Joe4]

You are welcome!