![]() ![]() 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. ![]() Now, to check the rows for all the other columns, I can hold down my Ctrl key and highlight the next pair of columns and hit the F4 key and it will continue to highlight the cells for those that are different.4 How to Remove to Highlighted Data How to Compare Two Columns in Excel to Find Differences In this case it highlighted cell B7 where "moulding" was spelled incorrectly, and B9 where the description was totally different. Now when I click on OK, it will highlight the cells in column B that are different than those in column K: Then I'll use my keyboard to enter the following keystrokes: To start, we'll highlight the two description columns, which are columns B & K: Now, with this process you can only compare two columns of data at a time, but once you've compared the first set of columns, the rest is quite easy. I can painstakingly go through each line to try to find the differences, or I can solicit Excel's help through the "Go To Special" command. Here I have two sets of data that appear to be the same:īut when I scroll down to the bottom I can see that the totals are slightly different: If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. We'll use the Go To Special command to help us highlight those differences. In this tutorial we are going to compare two data ranges that were supposed to be exact, but have some minor differences. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |