![]() ![]() The IF Function compares two columns, and if the values match, the Function returns “True” otherwise, it returns “False.” Now for every “True” value, it displays a specific text. Since the IF function makes a logical comparison between two values, let’s see how the formula works before getting into its example. The syntax of the IF function for this comparison is as follows: “OK,” if the employee logs out properly.“Forgot log out” if the employee forgot to log out.The result of the comparison must be something like this: Compare Two Columns Using the IF FunctionĬonsidering the above example again, let’s now compare the two columns, B and C, using the IF Function. This will help you filter out the employees who forgot to log out. Note: You may employ the filter function to immediately sort out the rows with the corresponding value ‘True’ in column D. Hence, as evident from the gif, two employees, John and Charles, did not log out properly. In contrast, False means that the log-in and log-out entries do not match each other. Here, ‘True’ means that the log-in and log-out time match, which in turn suggests that the employee forgot to log out. The output will be either “True” or “False,” as shown in the figure above.Īssuming that the value in column B is equal to the value in column C, you obtain “True” in the result and vice versa. Now drag the cell handle or copy-paste the formula to the remaining cells. You get a “false” value in return this implies that the value in cell B4 is not equal to that of cell C4. In cell D4, enter the operator “=” in the formula bar and select cell B4.Įnter the “=” operator again, followed by selecting cell C4. We use the comparison operator “=” (equal to) to find the exact match in two columns. Let’s now compare the columns and see the results. Since the office timings begin from 8:30, so the employees who didn’t log out will have the same log-in and log-out time. In this example, our objective will be to highlight the employees who forgot to log out using a simple Excel technique. Column A represents the names of the employees, whereas Column B and Column C display their log-in and log-out times, respectively. It reflects the record of 10 employees in an organization displaying their log-in and log-out time. Let’s explore these methods and related examples below:Ĭompare Two Columns Using a Simple Formula Method # 4: Compare two columns using conditional formatting.Method # 3: Compare two columns using EXACT Function.Method # 2: Compare two columns using IF Function.Method # 1: Compare two columns using a Simple Formula.The top four methods for comparing two columns are listed below: When comparing two cells, Excel matches each row of the first column against the second column to find the similarities or differences. It is fairly simple to use, and we have demonstrated the major ways to compare data for decision making as follows: There are hundreds of other cases which involve comparing columns. Similarly, you can find out the share price of your stock by comparing it with the stock data in a few clicks!.If you want to know the availability of certain gadgets from a huge list of items at your store – you can fetch the data by comparing your required items with the store inventory.Perhaps you want to find out which of your favorite football players qualified for a tournament – here you can compare your favorite players with qualified players and find out.Maybe you want to find the top-selling mobile phones at your store – you can compare the sales of mobile phone data to find the top selling phone.In case you are a beginner, let’s first familiarize ourselves with what the comparison of two columns in Excel is used for. This is one of the quickest techniques in Excel and can compare any amount of data in less than a second.Ĭomparing two data columns having 5 or 10 entries is a piece of cake, but what if you have thousands of data entries in both columns? The first step to compare columns typically involves comparing data by sorting it into two or more adjacent columns. You may want to Compare Columns in Excel to find matching, or non matching data, or simply to pull out specific information. Let’s see the versatility of Excel’s features for comparing two columns through the article below. The same is true for comparing two columns in Excel. Manually comparing data could take hours or even days, depending on the amount of the data in question.īut when it comes to using Excel, you can expect data work to be done in a matter of minutes When dealing with Data analytics, comparing data populated in two or more columns is common practice. ![]()
0 Comments
Leave a Reply. |