Comparing 2 data sets in excel

I have a report that I run on a monthly basis with various details for a set of employees. I am being asked if I can run another report that compares the currents months data to the previous months data
The report has around 20 columns and many rows (one row for each employee)

The new report (the changes report) should show :
- New employees added in current month
- Employees that were on the previous month but not on the current month
- Any information that has changed in any of the columns for an employee on both the previous month and current month report

The report has an employee number that could be used as a fixed identifier which is unique and does not change

Any help with the best way of doing this welcomed

Thank you

This comes to mind: If the version of Excel you're using supports it, Excel Spreadsheet Compare from Microsoft might give you what you want.

https://support.office.com/en-us/art...1-f15b3229f5d8

Pete