Excel 101 - Do These Cells Match? - Don't Fear The Spreadsheet - Episode 1597

1,682 views · Published 31 August 2012 · 5:15 · Indexed 27 October 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: How do I compare two Ranges of Data? 'Comparison Operators' are the key. 

Welcome back to the Don't Fear The Spreadsheet podcast. In this episode, we will be discussing a common question that many Excel users have - how to compare two different ranges of data to see if they match. This often happens when we send a spreadsheet to a co-worker and need to check if any changes were made. So, let's dive into the solution!

To start off, we have a list of names from Tom Urtis, one of the MVPs who wrote the book. This file is straight from the list of sample files that come with the book. In the last episode, we talked about formula operators like +, -, *, and /, but there are also comparison operators that can be used to test if two cells are the same. These include =, , =, , =, and <>. So, let's see how we can use these operators to compare our data.

First, we will use the = operator to check if two cells are equal. Every formula must start with an = sign, so we click on the first cell and then use the formula =A4=D4 to check if they match. If they do, we will get the answer TRUE, and if they don't, we will get FALSE. We can then copy this formula down and across to see which items match and which don't. This is a quick and easy way to identify any changes in our data.

Another way to compare data is by using conditional formatting. This allows us to highlight any cells that do not match using the <, >, <=, or >= operators. We can do this by selecting the range of data we want to check, going to the HOME tab, and clicking on Conditional Formatting. Then, we select "Use a formula to determine which cells to format" and enter the formula =D4<>A4. This will check if D4 is not equal to A4 and highlight any cells that do not match in red. This is a great way to visually identify any changes in our data.

Lastly, we can also use comparison operators to identify specific groups of data. For example, we can use the formula =B4>=40 to check if someone is 40 or over. This will give us a TRUE or FALSE result, which we can then copy down to identify all the individuals who fall into this group. This is just one example of how comparison operators can make our Excel formulas more powerful.

Thank you for tuning in to this episode of Don't Fear The Spreadsheet. We hope you found this information helpful and will join us for our next episode. And remember, don't be intimidated by spreadsheets - with the right tools and knowledge, you can conquer any Excel challenge. Don't forget to check out our book, Don't Fear The Spreadsheet, which breaks down complex Excel concepts in an easy-to-understand way. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction and Sponsorship
(00:14) Episode 10: Comparing Cell Data
(00:24) Question: Can we compare 2 different ranges of data?
(01:00) Using Comparison Operators (=, ,=, ,=, ) to test for equality
(02:09) Using Conditional Formatting to highlight changes in data
(04:14) Another use for Comparison Operators: identifying specific groups
(04:45) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
comparing ranges of data
comparison operators
conditional formatting
Don't Fear The Spreadsheet
Excel formulas.
formula operators
highlight changes
identifying groups
Podcast Episode Number 10
YouTube video search terms: MrExcel podcast


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153412/

Today, in Episode #1597, Bill looks at the need to compare two Ranges of Data to be sure they are Matched - and then he shows us how to do it. Follow along to learn the basics of Comparing Data from two different sources to reconcile for the final True result.

Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. http://www.mrexcel.com/dftss_home.html 


"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel