# Comparison

#### Avinashpv93

##### New Member
I have 2 salary register , in both column A contains employee name & B having amount of salary. So my problem is i want to compare both sheets to find out whether there is any difference.
So Mr.Excel is there any way to find out it by using formula..?

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Hi,

in first sheet (register1) column A names, colum B salaries

in C2 to obtain the differences between salaries in sheets register1 and register2

=B2-VLOOKUP(A2,register2!A\$1:B\$1000,2,0)

or

=B2-SUMIF(register2!A:A,A2,register2!B:B)

Hope it helps

The 1st one worked.., but now only i noticed one thing. Register 1 having 1348 employees & 2 having 1360..
So what to do now..?

Hi,

you could check employees missing in register1 using a countif in register2.

Example in register2 sheet in c2

=if(countif(register1!a:a,a2),"ok","missing")

Just to share other ideas

Hi.., i got it..
Thank you

Replies
3
Views
88
Replies
3
Views
203
Replies
1
Views
160
Replies
6
Views
147
Replies
2
Views
280

1,221,405
Messages
6,159,692
Members
451,585
Latest member
comanvitalie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back