Question: how to find the matches between two columns in excel sheet?
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.