![]() Confirm, and let’s have a look at other useful tricks that can help you efficiently compare the column contents. ![]() Let’s use this option and have the values highlighted in yellow. Of course, we can choose the colour we want to use to highlight the values. So, we want to highlight the values that are present only in one of the columns. ![]() ![]() Here in this window, we can choose whether we want to highlight duplicates – the values showing in the selected area twice, or we can choose the option ‘Unique’, which means that Excel will highlight the values that occur in both columns only once.Īnd this is exactly what we want because we can quickly find the differences between the columns in terms of the values they contain. Then we go to the Home tab, click on Conditional Formatting and hover over ‘Highlight Cell Rules’.įrom the options that appeared, we select ‘Duplicate Values’. To find differences between the contents of two columns in Excel, we need to select both columns first. 4 How to Remove to Highlighted Data How to Compare Two Columns in Excel to Find Differences
0 Comments
Leave a Reply. |