AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() They can be either in the same workbook or in two different files. On the first step, we should select the sheets to compare. That's it! Let's click Agree to move forward. Besides, the two sheets should have the same layout and structure including grouping, filtering, and sorting. To put it in short, please make sure your Excel files are saved, not protected, and there are no merged cells. I need the Compare Two Sheets tool.įirst of all, the utility asks you to get acquainted with the requirements and limitations. In the ribbon, I go to the Ablebits Data tab and find the Merge group. So, my key columns will be Fruit, Package, and Origin. I need to find rows that have same values in the columns Fruit, Package, Origin and see the different cells in these rows in other columns. The result you get depends on the key columns you select. So, the key column is the column which's entries are used to find matching and unique rows. And it will compare these matching rows, coloring the different cells in green. ![]() As soon as it finds the matching value, it will consider the found line as the matching row. The tool will take the value in the Fruit column of the first sheet and search for the same value in the same column of the second sheet. For instance, if I need to find differences between packages, origins, and prices of the same fruits, I will select the first column - Fruit - as the key column. You may ask: what is a key column? What do we mean when we use this term and why do we need it at all? The point is that key columns help you compare your datasets in different ways. I will compare the sheets by three key columns: Fruit, Package, and Origin. My task is to find differences in these two tables. The first column contains the name of the item, in the second I have the package, in the third is the origin of the product, and the fourth and the fifth columns contain prices. So here are my two price lists - Price list 1 and Price list 2. In this video, I will show how to compare two Excel sheets by several key columns and find differences.
0 Comments
Read More
Leave a Reply. |