Compare two columns in different worksheets
This article describes an array formula that compares values from two different columns in two worksheets twice and returns a […]

Compare two columns and extract differences
This article demonstrates formulas that extract values that exist only in one column out of two columns. There are text […]

Filter values that exists in all three columns
This article explains how to extract values that exist in three different columns, they must occur in each of the […]

How to highlight differences and common values in lists
This article demonstrates techniques to highlight differences and common values across lists. What's on this page How to highlight differences […]

Compare tables: Filter records occurring only in one table
Table of Contents Compare tables: Filter records occurring only in one table Compare two lists and filter unique values where […]

Filter values in common between two cell ranges
The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

Filter values occurring in range 1 but not in range 2
Table of Contents Filter values occurring in range 1 but not in range 2 Filter not shared values out of […]

Extract shared values between two columns
This article demonstrates ways to extract shared values in different cell ranges, two and three cell ranges. The Excel 365 […]

What values are missing in List 1 that exists i List 2?
This article shows how to compare two nonadjacent cell ranges and extract values that exist only in one of the […]