Hello,
I have a very large list of part numbers (26k+) that I need to load into my system at work. I can't load duplicates into the system which this list contains. I do however need to keep the duplicates and add a prefix.
I've tried the simple conditional formatting of highlighting duplicate cells but I have run into a problem. Many of the part numbers contain the same series of numbers forcing them to highlight whether they are duplicate or not.
For example, many numbers begin with 012 or 022, so the highlighted cells would include:

0120
0123
012
022
0220
0224

I have several numbers that are not duplicates as a result. Thank you for your help.