Hi All… I have a 2 excel sheet which is look like I have shared an image below. so, I have to compare 1st column from the 1st sheet and 1st column from the 2nd sheet. if it’s matched, I have to get the value from the 2nd column from 1st sheet and past it to the 3rd column to the 1st sheet. if it’s …

Hi @soundarya.a Make dictionary of the 2nd Data Table with key as the first column and value can be anything Use ContainsKey method to check if the Name is present or Not [image] [image] Refer the xaml file LINQ_DT_ComparisonWithDictApproach.xaml (11.6 KB) It is based on the approach by @ppr …

Excel compare 2 Column

Help Activities

soundarya.a (Soundarya A) October 10, 2022, 12:22pm 9

Hi @kumar.varun2
It worked. Thank you So much.

1 Like

Topic		Replies	Views
Compare 2 Column Activities excel , activities , studio	1	532	October 6, 2022
Linq to compare 2 excel sheets and select particular column to create 3rd sheet Studio excel	7	3258	March 17, 2020
Linq query for comparing 2 datatables Activities excel , activities , question	8	1914	July 6, 2023
How to compare the values of 2datatables Activities datatable , excel	3	1185	December 22, 2021
Compare two datatable Help activities , studio	9	2572	November 27, 2019

Excel compare 2 Column

Related topics