I want to quickly determine if 2 columns of data are identical. Ideally, I’d like to find some way to highlight the cells in the right column that do not match the left column. Is there a way to do this?
Thanks!
DeNae
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Compare 2 columns?
If this is a one-time review, take a third column & write the formula =a1=b1 (adjusted for your start position), copy it down, copy over the calculation with paste values, search and replace “TRUE” with nothing, and then inspect every row which says “FALSE”, since it failed to match.
If you are working on un-rounded formula number results, you may want to use =round(a1,6)=round(b1,6) to ignore insignificant floating point errors.
For frequent (or more complex) reviews, merge the two columns and use the Data, Filter, Advanced, Tool.
Select the second column
Format/Conditional Formatting
set it to Value is not equal to address of first cell in first column (no $s)
Click the format button select the Patterns tab and yellow or something
click ok
Example. If the first column is A1 to A24 and the second is B1 to B24 the conditional formatting box should say
Cell Value is | Not equal to| =A1
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications