I would to create two macros or vba code modules. That will check the records in a column and find duplicates. The second macro would find a duplicate and increase the sequence number by 1 in the duplicate row. I am including a sample spreadsheet below. Tab "A" I would to find just the duplicates. Tab "B" would find the duplicates and renumber the sequence number. The sequence number is in brackets.