FG
💻 Software

Find Items in one column that are not in another column

Fresh5 days ago
Mar 15, 2026691364 views
Confidence Score1%
1%

Problem

I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A. What's the quickest way to do this?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Find Items in one column that are not in another column

Low Risk

Select the list in column A Right-Click and select Name a Range... Enter "ColumnToSearch" Click cell C1 Enter this formula: Drag the formula down for all items in B If the formula fails to find a match, it will be marked #N/A, otherwise it will be a number. If you'd like it to be TRUE for match and FALSE for no match, use this formula instead: If you'd like to return the unfound value and return empty string for found values

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment