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...