If the formula returns TRUE, then the two-column values are precisely the same if it returns FALSE, they are different.Ĭompare Cells in the Same Row for Exact Matches or Case Insensitive (Using the IF formula) Press the Enter key and drag the fill handle down to cell D8. Usually, if you want to compare two columns row by row for an exact match, you can use the following formula: =B2=C2 Now all the unique names in both columns are listed.īelow is a dataset where I need to check in the same row whether or not the names in column A match those in column B.Ĭompare Cells in the Same Row to Get an Exact Match Select cell E2, and drag the fill handle to the cells that you want to contain this formula, after which all the names in column B have been extracted only as follows: Keep entering this formula: =IF((ISERROR(MATCH(B2,$A$2:$15,0,2))),BXNUMX,“”) into cell E2, and press Enter key:Ĥ. Drag the fill handle down to the cells that you want to apply this formula, and all the unique names in column A are only inserted once:ģ. Enter this formula in cell D2: =IF((ISERROR(MATCH(A2,$B$2:$B$14,0,2))),AXNUMX,“”), (A2 is the first cell inside column A that you want to compare with column B and range $2:$14 refers to another column you want to compare) and then press the Enter key:Ģ.To list unique values from the two lists separately, you can apply the following formulas: Suppose you have two lists of students' names in Column A and Column B of your worksheet, and some of them are in two columns, but, you want to compare these two columns and insert the different names from them.
0 Comments
Leave a Reply. |