Duplicate number increasing extention

Ok, I have aN eXCEL list of procuts, whos two main identifiers are Product ID and Sku. Product ID may have duplicate numbers based on if a product has choices for sizes or colors. Sku every choice or color has a different sku.
Example:

Sku - Product ID - Size/Color
113568 - 2097 - Red
113569 - 2097 - Green
113570 - 2097 - Pink
113571 - 2097 - Blue
113572 - 2097 - Purple
113573 - 2098 - None
113574 - 2099 - None
113575 - 2100 - Small
113576 - 2100 - Medium
113577 - 2100 - Large

What I need to do is take all the duplicate Product ID values and add a 4 digit incremental value on to the end. The first of the duplicared values has to be 1. The Product ID values that don;t have duplicates don't have to have the -0001, but it doesn't hurt if they do.
Example:

Sku - Product ID - Size/Color
113568 - 2097-0001 - Red
113569 - 2097-0002 - Green
113570 - 2097-0003 - Pink
113571 - 2097-0004 - Blue
113572 - 2097-0005 - Purple
113573 - 2098-0001 - None
113574 - 2099-0001 - None
113575 - 2100-0001 - Small
113576 - 2100-0002 - Medium
113577 - 2100-0003 - Large

Is there an easy way to do this? Doing it by hand to each one really is not fun.
Thanks!

Are those 3 different columns?

Yes, each set of text/numbers are in their own columns. Kinda hard to show that on here, so I used dashes as seperators. Thanks.

Originally Posted by cruizer

Ok, I have aN eXCEL list of procuts, whos two main identifiers are Product ID and Sku. Product ID may have duplicate numbers based on if a product has choices for sizes or colors. Sku every choice or color has a different sku.
Example:

Sku - Product ID - Size/Color
113568 - 2097 - Red
113569 - 2097 - Green
113570 - 2097 - Pink
113571 - 2097 - Blue
113572 - 2097 - Purple
113573 - 2098 - None
113574 - 2099 - None
113575 - 2100 - Small
113576 - 2100 - Medium
113577 - 2100 - Large

What I need to do is take all the duplicate Product ID values and add a 4 digit incremental value on to the end. The first of the duplicared values has to be 1. The Product ID values that don;t have duplicates don't have to have the -0001, but it doesn't hurt if they do.
Example:

Sku - Product ID - Size/Color
113568 - 2097-0001 - Red
113569 - 2097-0002 - Green
113570 - 2097-0003 - Pink
113571 - 2097-0004 - Blue
113572 - 2097-0005 - Purple
113573 - 2098-0001 - None
113574 - 2099-0001 - None
113575 - 2100-0001 - Small
113576 - 2100-0002 - Medium
113577 - 2100-0003 - Large

Is there an easy way to do this? Doing it by hand to each one really is not fun.
Thanks!

Please see attachment.

Column E and Column F has the formulas you need.

No offence, but something seems to go wrong at the 2099 mark. It's starting 2100 at 0002. I can't decipher the formula (Obvoiusly I am not that good at Excel0, so I can't tell what it is. But you definately know what I am looking for. Thank you.

Any other suggestions?

It works excellently! Thank you very much for you help! All of you!