Excel numeric values reconciliation

Help
,
1

Hi, everyone.

Now I have two sheets, and I would like to reconcile the numeric values of the two sheets in order to check they are the same or not.

For example:

Here is the data of sheet 1.

Account Balance
Cash 1,000,000
Accounts Receivable 500,000
Notes Receivable 2,000,000

And here is the other one.

Account Balance
Cash 1,000,000
Cash in Bank 5,000,000
Accounts Receivable 200,000
Notes Receivable 2,000,000

There are two situations. One is that both of the sheets have the same account,but the balance is different. And the other one is either sheet 1 or sheet 2 has the account, but the other one doesn’t.

I want users to choose these two files, and UiPath will automatically explore the accounts of the two sheets and emphasize the wrong cell.

For example, I want it achieve this kind of goal after executing UiPath.

<sheet 1>

Account Balance
Cash 1,000,000
Accounts Receivable 500,000
Notes Receivable 2,000,000

<sheet 2>

Account Balance
Cash 1,000,000
Cash in Bank 5,000,000
Accounts Receivable 200,000
Notes Receivable 2,000,000

Thanks in advance~

2

@DannyChung Can you provide Sample Input Files? Also make sure it has all the Columns that are need to be validated originally.