Jan 13, 2023

Compare two sheets and print difference in new sheet

Hello, all, hope your 2023 is off to a good start!

I have found threads/questions asking about comparing sheets but have not found one that explains how to propagate the difference on a new sheet. 

I have an example here https://docs.google.com/spreadsheets/d/e/2PACX-1vTkN1r6rMyE0U5luG2RIDX3fZnyeHk13ezhEBpVB0Qw3Xuf82Av6-ySSQ-x-vRq9SYc24reLwqtIzNV/pubhtml#

I have a list of items from month 1 in "Sheet 1" and items from month 2 in "Sheet 2". I would like display the additional rows in Sheet 2 in the new third sheet. Is there a formula or tutorial that I could reference to try and make that happen? 

Cheers
Corey
Locked
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Jan 13, 2023
All Replies
Jan 13, 2023
Hi Corey,

I believe what you're asking to be able to do is fairly straightforward. It would be easiest to demonstrate it if you shared a sheets file with the data you're looking to work with and gave us edit access to that file.  Also, if you include the desired output in the third sheet (no formula needed - just how do you want the results to come out).

The doc you shared isn't an editable sheets file for us.

Best,
Eric
false
2302579824707242136
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false