Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate unique values among duplicates | Excel Worksheet Functions | |||
Duplicates and unique values | Excel Worksheet Functions | |||
How do I sum unique values among duplicates horizontally | Excel Worksheet Functions | |||
check for duplicates, then sum unique values | Excel Discussion (Misc queries) | |||
Duplicates - deleting to get just unique ones | New Users to Excel |