Archive for Related tables
This post demonstrates how to merge two related tables before creating a pivot table. A pivot table is limited to […]
Use Conditional Formatting to do lookups in related tables
It can be really hard trying to follow a lookup in related tables. I will show you how to use […]
Working with three related tables
I have written a few posts about two related tables and today I am going to show you how to […]
Extract unique distinct values from a related table
In a previous post I described how to do lookups in a related table. In this post I am going […]
Lookups in a related table (array formula)
The "new" excel 2010 powerpivot feature and DAX formulas lets you work with multiple tables of data. You can connect […]
Search two related tables simultaneously [VBA]
Let´s say you do a lot of searches in two tables. The tables are related so it would be great […]
