Hi all,
I Have an excel with various Columns. In that excel one of the column is Reference Number.
I need to find if any duplicates are there in that excel with reference to the Reference Number.
The excel has around 5000 rows in it
How to do it. Please help me
You can use grouping with LINQ and keep only groups that are duplicate, what exactly do u want as an output?
@kali i want to write the duplicates into other excel sheet.
i am not aware how to use LINQ can you plz help me
can u send the excel file or is it sensitive? I can do it. are u using visual basic or c# for ur solution ?
its sensitive cannot share
I am getting The Source contains no DataRows error
Then there are no duplicates found u can handle this a couple of ways. But perhaps the simplest if ur not familiar with LINQ is by using a try catch like this.
@kali Thanks a lot for the quick response and it is working for me
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
