Tip: Isolate the later duplicates in a list

David H Ringstrom returns to the scene of one of his more popular posts to pick out the second and successive instances of duplicate values in an Excel list.

Accountants  frequently encounter transaction data and entries that can contain duplicate values, some of which are legitimate replications, but others may be mistakes.

The frequency of this experience may explailn while so many AccountingWEB members also read my tip on how to use COUNTIF to manage duplicate list values. A follow-up article explained how to identify duplicate values using just a couple of mouse clicks in Excel 2007 and later versions.

This technique just takes a few seconds to execute, but is limited in its use because it identifies all instances of a duplicate value.

After it appeared, I got a follow up request for a way to use Conditional Formatting to highlight just the second and subsequent duplications. This tip answers that question and also includes instructions on how to identify duplicate values in earlier versions of Excel that don’t have the built-in duplicate formatting feature.

Let’s start with a typical list of names, some of which are the same...

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.