Jan 13, 2023
Compare two sheets and print difference in new sheet
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
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
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