Excels with different data [Closed]

Report
-
Hi All,
sorry if this is already answered.

I have two excel sheet having data of customers. the first report is 'old' one and the second is the 'new'. I need to compare these two reports and produce below output:

1. all rows that are ONLY in the older report
2. all rows that are ONLY in the new report
3. if the rows are present in both reports, identify the columns that do not match.


my main identifiers for comparison are customer first name (column a) and last name (column c).

any inputs will highly help.