What's the difference? Comparing Two Columns in Excel by Simple Sheets

Comparing two columns in Excel is like I spy but for adults. In this video, we talk about a few methods on how we can do just that using Excel formulas and other built in tools! Some of the methods used in the video are: IF, ISERROR, MATCH, EXACT, Conditional Formatting, VBA.

Want to download amazing Excel templates? Try FIVE for FREE! Click below!

Timestamps:
00:00 - Intro
00:37 - Using MATCH in an IF function
02:37 - Non-case sensitive check
03:12 - Case sensitive check
04:23 - Conditional formatting
05:20 - Using VBA to compare two columns

#Excel #ExcelTips #CompareColumns

...

GET ACCESS TO 100+ Dynamic Excel Spreadsheet Templates

Project Management 📰
Marketing 📊
Supply Chain and Operations 🚚
Small Business 🦾
Human Resources 👨🏾‍🤝‍👨🏼
Data Analysis 👨‍🔬
Accounting 🧐
Finance 💵

These templates empower you to use Excel to streamline all your personal and business needs.

🦄 Customizable
🧨 Dynamic
🎨 Designed
🏭 Formatted
👩‍🏫 Instructions and Videos
📈 Reporting Visuals

Get 5 FREE Templates When You Sign Up 👇

Want to 🔐 new skills that improve your income, marketability, and expertise?

Our Excel University has 48+ lectures to help you master Microsoft Excel.

We'll walk you through everything you need to know to be an Excel Expert 🏆

🔎 Lookups
🔨 Functions
🧪 Formulas
📊 Charts and Graphs
🔢 Dashboards