I have 2 excel files that I need to compare. The problem is that one of the files has a total quantity for each price, and the other has the individual quantities at each price (e.g., file 1: 3 @ $10; file 2: 1 @ $10, 1 @ $10, 1 @ $10). I somehow need to be able to make sure that the quantities in the 2 files match at each price. If they don't, I need to be able to quickly find the differences. Any suggestions? Thanks in advance.