Other than the two methods shown above, another method to use is conditional formatting.Īnd in such a case, you have the option to highlight values that are different and the same. Highlight Rows with Matching Data (or Different Data) However, since we are using the IF function, we can ask the equation to return a specific value. It functions just the same as when using the equal sign with one profound difference: you will be able to decide the value to get when it comes to the resulting similarities or differences.įor example, you can decide for the result to show as “Match” for similarities and “Mismatch” for differences.Įvidently, the IF function and equal sign operator basically have the same formula. If you wish to see only the data that match or do not match, you can use the filter option.Īpart from the equal sign, the IF function can also be used to find similarities and differences when comparing two columns. If the data in Column A and Column B are the same, the result shows as TRUE. The simplest formula to do this is shown as =A2=B2. Using the Equal to Sign Operatorīased on the example above, you wish to see which of the columns have matching or non-matching data. However, there are simple ways of spotting differences in Excel using the different methods which will be illustrated in the next sections below. Manually entering data poses a higher chance of human error. If you wish to check whether the data in Column A versus the data in Column B is the same or not, let’s take the below table as an example. Probably the most basic method of comparing two tables is to look at the data in one table and compare it with the other. The methods used include the VLOOKUP Formula, IF Formula, or Conditional Formatting. This Excel article will provide the different methods of comparing two columns and finding their matches and differences. With small data, it is easy to spot similarities or differences.īut dealing with a large amount of information can be a challenge. This means that the formatting rule will go row-by-row and compare cells in Columns B and C.Īs a result, cells with different values have a red fill color.Working with Excel, especially with large amounts of data, could mean that you will need to compare data sooner rather than later. The formula has a dollar sign to fix columns, only changing rows. Then (3) click on the fill color icon, (4) choose red, and (5) click Done.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |