Compare two large excel sheets

Copper Contributor

Hi All,

I have two large excel sheets of projects information of almost identical data but sheet2 contains some incremental changes i.e. some new projects as well as some changes in the existing projects.

Whats the best way to compare two sheets and get only items which are added/updated in the second sheet.

1 Reply

The best way to my knowledge is to use a tool called spreadsheet compare (I believe it comes with Office Professional Plus):

 

Spreadsheet Compare.png

 

However, if you don't have that option I would suggest you go about it using one of the approaches addressed (One is VBA Driven and the other is Formula Driven) in this thread:

 

https://techcommunity.microsoft.com/t5/Excel/compare-two-worksheets-if-identical/td-p/195391