Identify Duplicate in Excel

Hi All,

I have a set of data that has duplicate records, so I need to comment it has Duplicate in status column…if I have the same item# number twice / thrice one should be left out blank and others should be mentioned has duplicate.

The output should be as below.

image

Regards,
Vinod

@vinod_ravikumar
Find some starter help here:
FlagNonDistincts.xaml (8.6 KB)

Thanks @ppr
Basically you achieved this through SQL query right.

@vinod_ravikumar
LINQ was used. Kindly note LINQ is not SQL. Have a look here:
https://www.tutorialsteacher.com/linq/linq-grouping-operator-groupby-tolookup

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.