![]() ![]() In our example, we wanted to check these two columns (B and C) and our data starts from row 3. Note that the formula may change based on the columns you have. In the formula field, write the following formula: =$B3=$C3.Select “Use a formula to determine which cells to format.” You will see a dialogue box with different options.Then, select “New Rule.” Figure 5- Highlighting matched values. Click on the “Home” tab and click on the “Conditional Formatting” option, in the Styles group.Select the table or the columns you want to compare.We can highlight them in the following steps: Highlighting Matched Data in One RowĬomparing two columns in Excel can also be done by highlighting the matched data. =IF(EXACT(B4,C4),”Vrai”,”Faux”) Figure 4- Case-Sensitive comparison.Īs you see, in this formula, “Blue Jeans” and “Blue jeans” are not the same. Thus, if any character in upper-case is important for your comparison, you can use this formula: Please note that this formula doesn’t make a case-sensitive comparison. See the result below: Figure 3- Comparing two columns in Excel with the IF method. Note: You can write whatever you want as a result instead of “Vrai” and “Faux.” In this case, you can write a simple IF formula. Therefore, the first method is not for you because it has a predefined text result. Or even a word in a language other than English. ![]() For example, you may need to see ‘Match’ if the cells have the same data or ‘NO’ to say the data are not equal. Sometimes, you may need to have an exact string after comparing two columns in Excel, or you may need to have a result with a particular text. Figure 2- Comparing two columns in Excel with TRUE/FALSE result Using IF formula method to match two columns in excel Remember, you can drag the formula cell to the end of the table, so the formula is applied on all rows. This will check the data in both cells and give two results: TRUE and FALSE. You only need to write a simple formula in the formula bar: (=B3=C3). We have chosen column D as the result column. First, select a column to see the results. Let’s compare the data in columns B and C, row by row. Check out the table below: Figure 1- How to compare two columns in Excel For example, you may need to know if C3 is the same as B3. In this method, you can find out if the data in one row in a column is equal to the same row in the next column. VLOOKUPFunction | Using Vlookup to Match DataĤ- Comparing Two Columns and Pulling the Matching Dataīottom Line 1- Comparing two columns in Excel row by row TRUE/FALSE method Highlighting Mismatched Data in Different Rowsģ- Comparing two columns in Excel to Find Missing Data ![]() Highlighting Matched Data in Different Rows Using IF formula method to match two columns in excelĢ- Comparing two columns in Excel by Highlighting 1- Comparing two columns in Excel row by row ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |