Join 3 excels based on one common column values

[Palaniyappan (Forum Leader)]

@7387023380

and all matched and unmatched rows for all IDs

Kindly have a view on this and it might help you

Unmatched records using LINQ

then you have to switch to: dt2 except commonrows Find demo here, hasib08_II_0.3.xaml (11.0 KB) take care about the renamed variables, do not copy paste blindly EDIT: 0.3 Version is returning dt2 rows from Common rows check, should be more safe at your end

@7387023380