Link to home
Start Free TrialLog in
Avatar of Svgmassive
Svgmassive

asked on

HIGHLIGHT DUPLICATES

see the attached file
DUPLICATES.xlsm
Avatar of [ fanpages ]
[ fanpages ]

Hi,

For the benefit of those that do not wish to open a workbook simply to read the requirements:

HIGHLIGHT DUPLICATE NAMES IN PERSONNEL IN BOTH COL A AND B(NAMES ONLY)

HIGHLIGHT DUPLICATE NAMES IN PERSONNEL IN  COL D (NAMES ONLY)

FORMULA AND VBA

Svgmassive: You are likely to receive more attention to your question if you provide more instructions within the question text.

BFN,

fp.
Avatar of Svgmassive

ASKER

got  you,I am trying to highlight the duplicates employees.i think it easier that way just to attached the workbook
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did that help?
no not realy
When I run the macro I get this. If the cells that are yellow are not what you want, please explain what's wrong.User generated image