In this video, I will show you six examples to compare two columns in Excel for matches and differences.
You can read more about this here: https://ift.tt/2BJshHp
The following examples are covered in this video:
— Compare two columns based on row values
— Compare and highlight values that are in both the columns (using conditional formatting)
— Compare and highlight values that are in one column and not in the other column
— Find names that are in column 1 and not in column 2 (using VLOOKUP)
— Pull matching data point
— 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.
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.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: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial