how to make reconciliations more efficient

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?

If you're attempting to marry the two columns together, I'd recommend using a vlookup or a search function.

Are you just trying to align the columns cosmetically or do you need data from F&G lined up next to A&B?

marry the columns together, heh, i like that.

i dont see the difference between the 2 questions but the second option seems closer. basically there's some data in A&B that doesnt exist in F&G, and i need to see what that data is so i can determine similarities in them.

that's awesome, thanks!

would you mind explaining the formula? i tried figuring it out myself, dont really understand it.