Compaing two worksheets

J

Julian Glass

Ive got two worksheets of employees each done a month apart. They contian
the same column / fields (20). One has 100 employees; the other 102. The
employee number is the key field.

I am looking for a formula(s) to identify which cells (of the 19 fields)
have changed for each employee.

I thought about concatenating the 19 fields and using looking, but this
doesn't tell me what cell(s) has changed for an employee.

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top