Hey, so I have two excel sheets and I want to find rows that are exactly the same from column A-E and rows that are different in any column. How would I go about doing this.
Have you tried using the Join Tool? The J anchor will show all matches. The R and L anchors will show mis matches.
Yea I have, would using the join tool and joining by every column header do the job? I was not sure if the join method would check if one of those is equal or if every field I add has to be true to join.
@smodu398 The join tool outputs to the J anchor only when all fields are matches.
I tried the join tool and chose every column header and it seems to be giving more than what I am looking for. Any other ways I could go about this.