PipMic
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Formula checks the sum (Col D) of both the sheet's Col A and shows you the difference.
Solution provided worked.
ASKER
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