Excel comparing data

Hi all,

Grateful for advice on creating a formula in excel.

I am attaching worksheet for ease of use.

I have two sets of data in two different tabs.

I'm trying to do  a a comparison of amounts based on column A, i.e. check column A in both tabs and if the you find the same number compare the corresponding amounts (total them if need be) and see if they are different. If they are, give me the difference.

I dont mind if this is done in stages.

Thanks
Test.xls
PipMicAsked:
Who is Participating?
 
ShumsDistinguished Expert - 2017Commented:
Hi,

Try below formula in E1 on a1 tab and drag down:
=IF(SUMIF($A:$A,$A1,$D:$D)=SUMIF('a2'!$A:$A,$A1,'a2'!$D:$D),"","Difference")

Open in new window

Check attached...
PipMic_Excel_Comparing_Data.xlsx
2
 
PipMicAuthor Commented:
It seems to work,  Will need to check.

I think I understand the formula,

i.e. in the column A get the value for A1... $D:$D)  (not sure about this???

Don't understand the comparison.....

Grateful for an explanation
0
 
ShumsDistinguished Expert - 2017Commented:
Formula checks the sum (Col D) of both the sheet's Col A and shows you the difference.
0
 
ShumsDistinguished Expert - 2017Commented:
Solution provided worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.