How to find 2 column's duplicate records in excel?

[Gokul001 (Gokul Balaji)]

Check out this thread @ozgecatak

Get value to DT from other DT using Linq

With the let statement we can memorize for later usage Here we check if there is right side join pair then use the col2 value otherwise it is set to null later when constructing the row itemArray we use the prepared value - b Yes we order the LINQ result on the left side datatable rows as mentioned by you about the requirements

Regards
Gokul