Solved

Excel Highlight Duplicates

Posted on 2011-02-20
4
426 Views
Last Modified: 2012-06-22
I would to create a macro where excel will look into column A and if there are duplicate values it will highlight the entire row where the duplicates exist. Any chance you can help me with this macro.

Thanks,

Chris
0
Comment
Question by:cansevin
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
aikimark earned 333 total points
Comment Utility
@cansevin

Take a look at the DuplicateMaster Add-in in this article.
http://www.experts-exchange.com/A_2123.html
0
 
LVL 50

Assisted Solution

by:Dave Brett
Dave Brett earned 167 total points
Comment Utility
All points to aikimark above please

Use the settings as per this screenshot

Cheers

Dave
sm.png
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 333 total points
Comment Utility
@Dave

Please take a look at this question where your Add-in experience might be beneficial:
http://www.experts-exchange.com/Q_26829378.html
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now