Sorry for the lame title.. lol

Heres what I have..

In Col. A I have a list of part numbers, some of them are duplicated, this is because the same part number applies to different descriptions. Well, my sql database doesnt care much for this and simply inserts the last part number that occures as an update to the preceeding part numbers.

What I would like to do is politely ask excel to simply add a "-1" "-2" or "-A" "-B" to the end of the part numbers that are duplicated.

Any ideas appreciated! Thanks!!
Matt