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.