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:

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