[image] [image] There are two sheets, 1 and 2 I check if the identity numbers are matched (use contains/equals) For error exception, i want to check (sheet 2 only) if identity number not inside sheet 1, print out the identity number. Result expected: 23456ABC invalid identity number the result…

HI @llllllkt99 Check out the XAML file TwoSheetCompare.xaml (9.6 KB) Regards Gokul

Invalid identity number

system (system) Closed November 19, 2022, 8:21am 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Comparing Excel Sheets with Different Row Count Help excel , activities , question	14	1593	January 13, 2020
How to compare 2 sheet and check status Activities excel	14	962	April 3, 2023
Not found error solution Studio studio , question , workflow_diff	9	370	December 13, 2023
Condition in if error? Activities excel , activities , question	27	2519	February 2, 2022
Contains is not a member of datatable Activities excel , activities , question	14	744	August 2, 2023