View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RKing RKing is offline
external usenet poster
 
Posts: 2
Default 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