Microsoft excel find duplicates in two columns

We can use IF & COUNTIF functions together to find data from the 1st column in the 2nd column for matches.

Like the picture below, youвЂ™ll see all the matches with the selected & highlighted colors.Дў.2 Combining IF & COUNTIF Functions to Detect Duplicates in Two Columns вћ¤ Select the color you want to show for highlighting the duplicates. вћ¤ Under the Home tab & from the Conditional Formatting drop-down, select Duplicate Values from the Highlight Cells Rules. To find duplicates in two columns in any rows, you can directly use the related command in Conditional Formatting for highlighting. Finding Duplicates within Any Rows in Two Columns 2.1 Applying Conditional Formatting to Locate All Duplicates in Two Columns In the picture below, the matches in the same rows are now visible with the selected color.Дў. вћ¤ Press OK for the last time & youвЂ™re done. вћ¤ Press OK & youвЂ™ll be shown the Sample format with selected color in the New Formatting Rule dialogue box. вћ¤ From the Fill tab, select a color that you want to use for highlighting the duplicates.

вћ¤ Select Format option & another dialogue box will appear. вћ¤ In the Rule Description editor, type =$B5=$C5 вћ¤ Now select the rule type to use a formula to determine within cells to format. вћ¤ Under the Home tab, from the drop-down of Conditional Formatting in the Styles group of commands, select the New Rule command. вћ¤ Select the whole range of cells that is considered for finding duplicates. If you want to find duplicates within the same rows in two columns then probably conditional formatting suits best to highlight the matches and it wonвЂ™t let you type any function to search for matches. вћ¤ Use Fill Handle to autofill other cells in Column D & youвЂ™re done.ДЎ.3 Applying Conditional Formatting to Highlight Matches within Same Rows in Two Columns

Microsoft excel find duplicates in two columns