Identify Duplicate in Excel

Help
, , ,
1

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

2

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

3

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

4

@vinod_ravikumar
LINQ was used. Kindly note LINQ is not SQL. Have a look here:

6

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