Hello Experts, I want to compare the data in two columns of the excel. If there is mismatched data in the columns, I want to highlight the mismatched data and extract the missmatched data. I attached the sample excel file for reference as below. If there is any solution or workaround, please let …

UnmatchedRecordBasedOnCol.xaml (8.9 KB) @Zaw_Win_Htun1 , PFA the .xaml for your reference.

How to compare two columns and find missing data in Excel

Zaw_Win_Htun1 (Zaw Win Htun) August 25, 2022, 8:01am 5

hi @Sanjit_Pal How can I convert to system.collections.enumable(of string) to datatable to wirte in excel.

Topic		Replies	Views
How to compare two data tables and look for not matching row columns data? Studio datatable , excel , activities , question	3	910	January 6, 2023
DataTable Comparison Help	1	1378	May 20, 2019
Compare two DT with one column and get unmatched records Studio datatable , excel , question	16	6184	September 28, 2020
Comparing two data tables and finding the missing items Studio studio , question , output_panel	5	1445	July 4, 2022
Comparing row and column Automation Starter	5	641	September 11, 2022