Videos | Books | What's New | FAQ | Testimonials | Buy Credits | Support | Login | My Account

Finding Duplicates in a list Added to Library on 24 Jan 2007 Length: 5 mins View Tutorial Movie Download File Used This tutorial illustrates a really neat trick in Excel that allows you to use the COUNTIF function and conditional formatting to highlight duplicates in a list. The example uses email address for a marketing campaign but the techniques shown here can be used for any type of list. Related Tutorials: Introduction to Conditional Formatting Removing Duplicates from a list Feedback for this tutorial: "This can be very useful in the accounting world as well. I think this is going to be something I use regualarly." "Clayton, This is one of your best! Leigh" "Whilst this contained nothing new for me it was an excellent example of how to use conditional formatting in a very practical setting. Well done Clayton!" "Easier than writing a macro to accomplish this task." "Thanks Clayton, I've seen this at work but NEVER knew how easy it could be to set up and use." "Hello Clayton, An excellent application of simple common sense; thank you very much...you have done a lot to make me confident of working with excel files.. " "Simple but very powerful. Very well explained!" "Wow, this is a real time saver when creating long list. Once again many thanks Ollie" "This will take some practice, but can't wait to use it. It's impressive." "this tutorials help much to a beginner like me, it's easy to understand. thank you very much" "I will apply this technique of finding duplicate data to several of my excel spreadsheets. Thanks." "Hi Clayton, Todays tutorial was fantastic. This is going to help me alot. Yakubu Abdulai Ghana "