Find missing report name

i have two excel one excel contains 4 report names and other excel contains 6 report compare both and find any one is missing from 4 report names and send mail report is missing


Can you provide an excel sample of each?

That way a solution can be developed based upon your column names.

copy.xlsx (9.6 KB)
this is my excel here sheet 2 column name is Transaction_Reference have 4 report and sheet1 column Transaction_Reference have 5 report if any report missing from shee2 then send mail report is missing

Hey @Yogita_Gaikwad

Take a look here.

Orange = Match
Red = No Match.

Result File:
Input.xlsx (11.2 KB)

Main.xaml (13.4 KB)

The results are saved in a new tab called “RESULT”.

Hopefully this helps you :blush: