I have extracted data from two systems into two seperate excel spreadsheets.
they should be identical but are not. I would like to compare them to see
which spreadsheet is missing information.
Sheet 1 has - (a1) emp no (b1) hours (c1) date (d1) project id
Sheet 2 has the same columns but has 60 extra rows
I have sorted both sheets by emp no, date and project id
I used a pivot table to show that multiple emp nos do not have the same
hours over the two spreadsheets. I need to compare the information to ensure
(a1) emp no, (c1) date and (d1) project id are all equal and then determine
where I am missing rows of information or if the information there is
incorrect. Can anyone help me?