Compare difference between 2 worksheets 2003

A

Annie

Hi

I have one worksheet with 600 rows of information about employees i.e. emp
no. name, salary etc.. I have a second worksheet which contains the same
information but some of the salaries may have changed - I need to compare
these to see which cells are different How can I do this.

Also, similar problem - I have one sheet with employee salary information
and another sheet with employee details and pension information. How can I
compare to see which employees are on both sheets?

Many thanks
 
E

Eduardo

Hi,
Let's say you have the names in column A and the salaries in column B in
both sheets called A and B , and the information is in a tab called Sheet1,
in column C sheet called A enter the formula as follow , I assume the names
are exactly in the same format

=SUMPRODUCT(--(A2=Sheet1!$A$2:$A$6),Sheet1!$B$2:$B$6)
 

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

Similar Threads

Possible to have multiple sheets refer to a master template sheet? 1
Compare worksheet data 0
Linking sheets to summarize data 1
vlookup 3
Compare 2 worksheets 1
Creating worksheets automatically 3
IFERROR TO COMPARE WKSHEET 2
Comparing the difference between 2 worksheets 2

Top