In looking at the example workbook you posted at #4, I see the values in C Column that can be duplicates.

It seems very unclear to me what you want to do with the numbers or records.