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
Community content may not be verified or up-to-date. Learn more.
Last edited Jan 13, 2023
All Replies