Question: how to find matches in two different columns excel?
Answer: Select the entire data set., Click the Home tab., In the Styles group, click on the 'Conditional Formatting' option., Hover the cursor on the Highlight Cell Rules option., Click on Duplicate Values., In the Duplicate Values dialog box, make sure 'Duplicate' is selected.