Duplicates-to id when occurs in 3 columns for unique dup in 4th co
 

Need to identify when duplicates occur in columns 1, 2, 3 (each having unique
data that can reoccur numerous times), but only need when this occurs for a
unique duplicate in a 4th column. Using MS 2007. File is 6,000 + lines. Ex.
below with astericks is the only match I need to id. Thanks!

Column A Column B Column C Column D
123 20 Item1 053009 *
456 30 Item1 053009
789 40 Item1 052709
123 20 Item1 053009 *
789 40 Item2 052809
456 30 Item2 052809
456 30 Item2 052609

Duplicates-to id when occurs in 3 columns for unique dup in 4th co
 

I would add a couple of helper columns and fill them with formulas:

Say in E1
=a1&"..."&b1&"..."&c1
(the dots are there to make the concatenated string unique).
and fill down as many rows as you want

Then in F1
=if(countif(e:e,e1)=1,"","*")
and fill down as many rows as you want


rking wrote:

Need to identify when duplicates occur in columns 1, 2, 3 (each having unique
data that can reoccur numerous times), but only need when this occurs for a
unique duplicate in a 4th column. Using MS 2007. File is 6,000 + lines. Ex.
below with astericks is the only match I need to id. Thanks!

Column A Column B Column C Column D
123 20 Item1 053009 *
456 30 Item1 053009
789 40 Item1 052709
123 20 Item1 053009 *
789 40 Item2 052809
456 30 Item2 052809
456 30 Item2 052609

--

Dave Peterson