with the formula CONCAT(A1:D1), it will concatenate contents of A1, B1, C1 and D1. this function concatenates the content of the the cells that is passed to it as range. To do that, we will use and excel function called CONCAT. The trick that I am going to use is compare content of a row in in one sheet to the content of same row in the other sheet.
But approach would be the same for sheets in different excel workbooks. in this article we are showing the sheets are in the same Excel workbook. We will take another sheet to compare sheet1 and sheet2. Contents of the cell which has different value has been highlighted You can have a look at the two pictures of sheet1 and sheet2. number of rows and columns can quickly be verified by visually checking Find which rows are same in two sheetsīefore we explore this situation, let us visualize what we are talking about Suppose, we have two sheets that have different values in some cells. If the sheets are in question have different number of rows or columns, then it is obvious that those two excel sheets do not contain same data. Lets look at some scenarios and and find probable solutions Find if Two Sheets are same or not Visual identification On the other hand, you might be looking for actions and that could be just identification, or removal of duplicates or sometime there could be more actions. Some time, you might be more interested in rows or cells level. You want to figure out if two sheets are similar or the same. For example, it could be at sheets level.
COMPARE 2 COLUMNS EXCEL FIND DUPLICATES HOW TO
How to figure out duplicates? There could be different dimensions of duplicate data. While working with excel, I believe, everyone faces this situation sometime or other.