This may sound minor enough but it took me an hour to reconcile 700 lines so I’m wondering if there’s an easier way.
Refer to attached file. Col C shows the discrepancies. You’ll notice that when there’s a discrepancy you simply move the data on the right side down a row or two, and that resolves it. So for example, row 7 matches, row 8 does not; highlight F8:G8, click insert, and now the data matches.
The problem is, when you do this, the formula in col D which is checking for discrepancies, also gets messed up. Is there a way to avoid that?
Bookmarks