CODEWITHSUNDEEP
excelcompare
h3x3n95
h3x3n95

Reputation: 37

Finding differences in two excel sheets

I have two sheets in excel that each have three columns: Id, Description1, Description2.

Sheets Example

Both sheets will have the same ID's in the first column, however some of them have different descriptions.

I'm trying to compare both and remove the rows that are completely identical. Thus, leaving only the rows with differences left. And preferably place those differences in a new sheet.

I'm unfamiliar with the excel syntax, could someone please give me an idea of how to accomplish this?

Thanks

Upvotes: 0

Views: 369

Answers (1)

h3x3n95
h3x3n95

Reputation: 37

Used the remove duplicate function within excel as suggested by Harun23HR.

Upvotes: 0

Related Questions