I would like a macro for identifying duplicate photo names in an Excel spreadsheet. There are multiple photo names in each cell in column E.
All of the photo names are in column E and have the format [url removed, login to view] so they all start with 'D' and end with 'G'. 'D' and 'G' are never used in any other part of the photo name so they could be used for parsing the column E values if needed.
I need the cells that have duplicate values in column E identified and written to a new worksheet named 'Duplicates' with their corresponding row number where they exist.
Example spreadsheet provided.
Forgot to mention...the photo name "Click1.JPG" will be in every column E cell, the macro logic should not report this photo name when identifying duplicates.