Excel - Identify Duplicate Values Within Cells For Column

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.


Taidot: Excel, Visual Basic

Näytä lisää: excel duplicate values, identify duplicate name excel, new excel, macro excel, macro e, macro + excel, jpg to excel, identifying, identify, format excel, excel duplicate, Column, cells, multiple excel, cell names, excel row column, excel macro row, duplicates excel, excel column row, excel format cell, excel cell format, excel cell, format cell, column row excel, spreadsheet photo

Tietoa työnantajasta:
( 6 arvostelua ) Robbinsdale, United States

Projektin tunnus: #482162

Myönnetty käyttäjälle:


I am new to GetAFreelancer but can easily complete this project within 2 days Regards

$35 USD 2 päivässä
(2 Arvostelua)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Your Project is almost complete. How can I send it you it to you.

$30 USD 1 päivässä
(13 arvostelua)