Script to check for duplicates in one column then alter adjacent column values

One of them could inject some irony into this thread by writing code to carry out Stephen's solution.

Edit - HA! He did it on his own before I completed my post.