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.
7 Responses to “Build models & dashboards faster with Watch Window”
yes, I use watches in excel vb
Dear Chandoo,
This is a quite useful for myself. I highly appreciate your efforts for acquainting us with this value adding and time saving tip.
I'll admit it, I never saw this feature before. I was familiar with using Watch Window in VB, but not in workbook. I'll definitely use this in future when building dashboards!
it was always great reading your blog, one thing that i want to know, which tool you are using to create such gif image?
it was also a nice post,,,,,, sir
Hello Sir,
Really very nice post. I didn't use this features in past. But now going to use it..
Thanks a lot for every time come up with something new..
Thanks
Very Nice post sir.
Every Time posting something new.. Thanks a lot