Excel: Compare 2 Columns (8 Different Cases)

8 different cases are shown in this video on how to compare 2 columns.

Content:
*Compare 2 columns and return result:
**case#1: Same Row & Non-Case Sensitive (00:04)
**case#2: Same Row & Case Sensitive (01:17)
**case#3: Different Row & Non-Case Sensitive (02:33)
**case#4: Same Row & Non-Case Sensitive (04:05)

*Compare 2 columns and highlight result:
**case#1: Same Row & Non-Case Sensitive (06:00)
**case#2: Same Row & Case Sensitive (06:44)
**case#3: Different Row & Non-Case Sensitive (07:30)
**case#4: Same Row & Non-Case Sensitive (07:55)

Thanks for watching

To subscribe:

To watch full playlists

Formula - Logical:

Formula - Text:

Shortcuts:

Basics:

Different Ways:

Tips & Tricks: