intofoki.blogg.se - Compare two columns in excel for differences

“=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.

A difference (column A is not equal to column B) implies employees who took either three or two continuous leaves.

A similarity or a match (column A is equal to column B) implies employees who took both three and two continuous leaves.

Since the data pertains to the same organization, there can be a similarity or a difference within the given set of values. Column B lists the names of the employees who took two consecutive leaves.Column A lists the names of the employees who took three consecutive leaves.In contrast, the differences are those values that exist in only one of these columns.įor example, for a specific month, a table displays the following information:

The similarities are the data values that exist in the same row of both the compared columns. Two columns in excel are compared when their entries are studied for similarities and differences.