This post demonstrates how to merge two related tables before creating a pivot table. A pivot table is limited to […]

Comments(7) Filed in categories: Excel, Pivot table, Related tables

It can be really hard trying to follow a lookup in related tables. I will show you how to use […]

Comments(1) Filed in categories: Excel, Related tables

I have written a few posts about two related tables and today I am going to show you how to […]

Comments(10) Filed in categories: Excel, Related tables

In a previous post I described how to do lookups in a related table. In this post I am going […]

Comments(7) Filed in categories: Excel, Related tables

The "new" excel 2010 powerpivot feature and DAX formulas lets you work with multiple tables of data. You can connect […]

Comments(3) Filed in categories: Excel, Related tables

Let´s say you do a lot of searches in two tables. The tables are related so it would be great […]

Comments(0) Filed in categories: Excel, Related tables