How To Highlight Duplicates In Excel In Two Columns Link

=COUNTIF(A:A, B2) > 0

| | Column B | | --- | --- | | John | Jane | | Jane | John | | Joe | Mike | | Mike | Joe | how to highlight duplicates in excel in two columns

Enter the formula:

Finding duplicate data across two columns is a critical task for data cleanup, auditing, and reconciliation. Excel provides multiple native tools to accomplish this efficiently. Method 1: Use Conditional Formatting (Built-In Rule) =COUNTIF(A:A, B2) > 0 | | Column B