Please i have two lists in excel and will like to compare to extract exceptions[ one list is typically more than the other] Here are two examples;
Example A [input] Example B [input]
LIST 1 LIST 2 LIST 1 LIST 2
A1 A1 A1 A1
A1 B5 A1 A1
B5 C6 B5 C6
C6 D4 C6 D4
From the examples above, the desired output after comparing the lists in example one should be “A1”[ which is the only variable in List 1 that is not in List two since it appears twice in list 1.
From the 2nd example the desired output is “B5” and “D5”, which are the only variables in List 1 that are not in list 2.
Can i get some help with this in workfusion. All this will be done in excel.