![]() We can use the EXACT function to find the exactly matched values. “Milk” and “milk” are treated as the same in this comparison. If the cells A2 and B2 are the same, “Matched” value will show in cell C2 and if the cells A2 and B2 are not the same, then the “Not Matched” value will show as the output. This is a straightforward Excel IF function. We have used this formula in cell C2: =IF(A2=B2, “Matched”, “Not Matched”) You might also want to compare two columns row by row like the following image. Related: How to Compare Two Columns in Excel For Finding Differences 5) Compare two columns row by row ![]() So, this formula will return 600 as a value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |