Comparing two modules
I am trying to make a module to compare two modules to see which values they share and which are missing from either. The values I’m comparing are 3 text line items and I wish to make 2 columns holding the results of if the value is missing from that module Boolean. I’ve tried using compare but I’m having issues as there are a different amount of rows of data in each module and the data doesn’t appear in the same order. I created a third module that includes all of the data from the two modules I am comparing but I am stuck on how to set up my comparison module and what formulas to use for the boolean/results column.
Any help is GREATLY appreciated!!!