![]() ![]() #4 – Compare 2 Excel Columns Using Conditional Formatting This function is a logical function, so it provides true or false as a result. Working on the data of example #1, we want to compare the two excel columns B and C with the help of the EXACT function EXACT Function The exact function is a logical function in excel used to compare two strings or data with each other, and it gives us the result whether the both data are an exact match or not. Hence, Roshan and Uday are the only two employees who have forgotten to logout from the office. The output is shown in column E of the following image. If the value in column B is equal to that of column C, the result is “true,” otherwise “false.” For every “true” value, the formula returns “forgot to punch out.” Likewise, it returns “no problem” for every “false” value. “=IF(B2=C2,“Forgot to Punch Out”,“No Problem”)” Read more to compare the columns B and C. It is a conditional function of Excel, which returns the result based on the fulfillment or non-fulfillment of the given criteria. Use the IF function IF Function IF function in Excel evaluates whether a given condition is met and returns a value depending on whether the result is “true” or “false”. “Forgot to punch out,” if the employee forgets to logout.Working on the data of example #1, we want the following results: #2 – Compare 2 Columns Using the IF Formula ![]() Hence, Roshan and Uday forgot to logout from the office. If the value in column B is equal to that of column C, the result is “true,” else “false.” The cells D5 and D9 show the output “true.” The output is either “true” or “false,” as shown in the following image. Drag or copy-paste the formula to the remaining cells.It returns “false.” This implies that the value in cell B2 is not equal to that of cell C2. Enter the symbol “=” again, followed by selecting the cell C2.In cell D2, enter the symbol “=” followed by selecting the cell B2.The steps to compare two columns in excel with the help of the comparison operator “equal to” (=) are listed as follows: Hence, there are techniques which can be followed to compare 2 columns of an excel worksheet. ![]() It is difficult to scan through the data to track the matches and the differences manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |