Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare difference between 2 worksheets 2003
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 -- Kind regards Ann Shaw |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare difference between 2 worksheets 2003
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=[b]Sheet1!$A$2:$A$6),[b]Sheet1!$B$2:$B$6) "Annie" wrote: 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 -- Kind regards Ann Shaw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two columns and find the difference between the two column | Excel Discussion (Misc queries) | |||
Compare data from two worksheets and display difference into 3rd s | Excel Worksheet Functions | |||
Can you compare similar spreadsheets to determine a difference? | Excel Discussion (Misc queries) | |||
How do I compare the difference in two spreadsheets? | Excel Worksheet Functions | |||
How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) |