Author: Oscar Cronquist Article last updated on January 29, 2019

This article demonstrates how to filter records occurring in only one out of two Excel defined tables. It also shows you an array formula that extracts records not shared by both data sets.

Let me demonstrate how to extract non-common records from two tables.

The formulas in this post contain the COUNTIFS function and were introduced in Excel 2007.

The first example shows you how to hide common rows in a table.

The second example describes how to compare two tables and extract not common rows/records using an array formula.

Example 1 - Excel defined tables

Sheet 1 and sheet 2 contains random data. As you can see, row 1 and 3 are common records between the two tables.

Sheet1

Sheet2