Check duplicate values in a column and update the status

Along with some chance to customize / hybride approach with LINQ you can do it with grouping the data and processing the group member by this filter approach:

taken from: [HowTo] Overview on different options for grouping data and processing the groups