Excel How To Compare Two Columns (3 ways) | Excel Formula Hacks

In this video, I'm going to show you how to compare two columns in Microsoft Excel. I'll be demonstrating 3 different methods to compare two columns:
- conditional formatting when lists are on same sheet
- COUNTIFS to count the number of matching rows
- SUMIFS to retrieve the amount for comparison

Chapters in this video:
00:00 - Introduction
00:22 - Conditional Formatting
01:10 - COUNTIFS
03:04 - SUMIFS

If you need to compare two columns in Microsoft Excel, then this video is for you! We'll show you how to use different methods to compare the data in the two columns, and how to find the difference between the values in the two columns. Whether you're a beginner or an expert, this video is a great way to learn how to compare two columns in Microsoft Excel!

[varshanookarapu]

Thank you so much i was able to complete a comparison task in less than five minutes :)

[fdadrtrttewrt]

I got the answer I needed in around 30 seconds. Thank you!

[danmack]

Thank you for posting this!! Much appreciated. You just saved me a lot of work.

[jayxpea]

thanks for this. As much as I like countif/s sumif/s functions its very resource heavy. For big data sets it causes excel to lag and freeze

[sahilkhan]

Hi, i am a CPA in progress and this helped me a lot. Gr from Amsterdam

[jesus.moreno]

muchas gracias man ... i was looking for this ... god bless you!

[kristasimonetti]

I have two columns. In Column 2 (the longer list of numbers), I want to highlight the numbers that are in Column 1. I do NOT want to highlight the duplicates WITHIN Column 2. Is this possible?

[mattparadise]

How do you compare two columns? I have searched and searched. I have two columns of numbers and want to have one cell at the top that simply will tell me if ANY records in column A exist in Column B.