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:29am 7

Hi @Sanjit_Pal If possible, could you please share me the workflow. Best regards.

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