Row report to show data from 2 sheets if column data matches both

Options

I have 2 sheets with very similar, if not identical, data except each sheet is for a different year.

I am looking to create a row report to show only the data if the category column matches on both sheets to compare the differences from this year to last. I already have a formula to remove the parent row from the report. I am looking to remove the categories that haven't been completed in both years (Analgesics, Aseptic Juice, etc). Any ideas?


2022

2021


Answers