This can be done different ways depending on a couple things:

If you know all the names that will be on the 2 sheets, and you just want to
see when there's a mismatch, you can do:

Column A Column B
Rep Name Disposition
John
=sumif(Sheet1!A:A,A2,Sheet1!C:C)-sumif(Sheet2!A:A,A2,Sheet2!C:C)

This will show the $ difference between sheet1 and sheet2 for each rep name.
If it's positive, this means sheet 1's wages are higher, and vice versa.

That's a simple method, but does depend on you knowing all the names from
both spreadsheets in advance.

HTH

"payroll" wrote:

I am inexperienced with excel so any suggestions are welcomed. I have two
different spreadsheets with columns of name, hours worked, total wages. Each
name has a different row for each type of wage. A person can have several
rows. There are no subtotals. I want to know how to compare each spreadsheet
and find the differences. Essentially I want to know if the total wages on
the first spreadsheet match the second spreadsheet. If wages have been
partially or completely dropped, or duplicated etc... a report would
generate. Similar to balancing a checkbook. Thanks.