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.

[TABLE="class: grid, width: 150"]
<tbody>[TR]
[TD]Col A
[/TD]
[TD]Col B
[/TD]
[/TR]
[TR]
[TD]114-1
[/TD]
[TD]114
[/TD]
[/TR]
[TR]
[TD]114-2
[/TD]
[TD]114
[/TD]
[/TR]
[TR]
[TD]114-3
[/TD]
[TD]114
[/TD]
[/TR]
[TR]
[TD]114-4
[/TD]
[TD]114
[/TD]
[/TR]
[TR]
[TD]115-1
[/TD]
[TD]115
[/TD]
[/TR]
[TR]
[TD]115-2
[/TD]
[TD]115
[/TD]
[/TR]
[TR]
[TD]116-1
[/TD]
[TD]116
[/TD]
[/TR]
[TR]
[TD]116-2
[/TD]
[TD]116
[/TD]
[/TR]
[TR]
[TD]116-3
[/TD]
[TD]116
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!