In this video, I will show you six examples to compare two columns in Excel for matches and differences.
------------------------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00: 10 Compare two columns based on row values
01:04 Compare and highlight values that are in both the columns (using conditional formatting)
01:42 Compare and highlight values that are in one column and not in the other column
02:17 Find names that are in column 1 and not in column 2 (using VLOOKUP)
04:05 Lookup and get matching data point
04:37 Pull matching data point when there is a partial match
------------------------------------------------------------------------------------------------------------------------------------------
Based on your dataset, you may need to change or adjust the method. However, the basic principles would remain the same.
You can read more about this here: trumpexcel.com/compare-two-columns/
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: trumpexcel.com/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
- Compare Two Columns in Excel (for Matches & Differences) ( Download)
- Compare Two Columns in Excel (for Matches & Differences) ( Download)
- How to Use Excel to Match Up Two Different Columns : Using Excel & Spreadsheets ( Download)
- How to Compare Two Columns in Excel to Find Differences (The Easiest Way) ( Download)
- Compare Two Columns in Excel to Find Differences or Similarities ( Download)
- Excel How To Compare Two Columns (3 ways) | Excel Formula Hacks ( Download)
- Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick ( Download)
- How to highlight values that appear in two columns | Compare Two Columns in Excel for Matches ( Download)
- Master Excel 2024: Pivot Table Options, Grouping, Slicers & Timelines Uncovered! ( Download)
- How to Compare Two Columns in Excel For Matches & Differences Using Formula ( Download)
- How to Compare Two Excel Sheets and Find Differences ( Download)
- How to compare two columns in Excel for matches and differences ( Download)
- How To Compare Excel Files and Find Differences ( Download)
- Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. ( Download)
- How to Compare Two Excel Sheets and Find Differences ( Download)