I have two arrays of many rows , in my Google sheets, which have numbers such as
I have shown only two rows to explain my problem. In the second row, you see that
202 is common. These rows are populated by complex calculations over which I have no control 1. Logically, if the element is common (
202 here), it should appear only under
Active and be removed from
How do I compare and remove the common element? Or at least alert me that a common element exists so that I can manually copy-paste that row and delete it?
Active column is populated a formula like
Recovered and I have no way of accessing the source. My job is to report the output and only today noticed the duplication