💻 Software
How to quickly check if two columns in Excel are equivalent in value?
Fresh5 days ago
Mar 15, 2026325945 viewsConfidence Score0%
0%
Problem
I am interested in taking two columns and getting a quick answer on whether they are equivalent in value or not. Let me show you what I mean: So its trivial to make another column (EQUAL) that does a simple compare for each pair of cells in the two columns. It's also trivial to use conditional form…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to quickly check if two columns in Excel are equivalent in value?
Low Risk
This is the sort of thing array formulas were designed for. You just need one cell, one formula to give you a comparison: Enter the formula by pressing Ctrl+Shift+Enter. If done correctly it will appear as the following: EDIT: For a case-sensitive c…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix