Matching transactions using pivot tables

Last week, we learned how to use formulas to reconcile (match) transactions in Excel. Today, lets take a look at even faster and simpler way to do this:

Using Pivot Tables

Here is a short video explaining the technique and why it works. See it below

(or watch it on our youtube channel)

Download Example workbook:

Please click here to download the example workbook & play with it.

Hungry for pivot tables? Grab these juicy stuff:

• Learn how to create and use Pivot Tables in Excel
• Excel Pivot Tables – Tutorials, information & tips

Thanks to commenters Utkarsh, Heather, Carlos & Kerry for suggesting that we use Pivot Tables for this problem.